SQL101
SQL101-Homework Assignment #1 Answer Key
As promised, here are my answers to the first homework assignment. If you have something different, please get in touch with me so we can discuss the
Latest
microsoft sql
SQL101-Homework Assignment #1
Here are some practice problems for you to attempt using what you've learned so far about SELECT Statements. Please write the following queries against any
sql
Duplicates
Duplicates. I honestly can't tell you how many times the root cause of a problem has been records in a table get repeated, where there should never be
sql
A Better sp_who2
If you've ever needed to work with sp_who2 to figure out what's going on, then you know it would be nice to be able to sort the results, right? Well, if you use
t-sql
Moving Data Between Tables
Very early into my SQL career I had to get comfortable moving records around between tables and databases. There are several ways to do it, you just have to
Certification
70-432:Multiple Solutions, Multiple Instances
At work our database server is humming along. It runs a little under 50% on the CPU, the RAM is a bit high, and the IO is very responsive. But, it could be
Posted in: Microsoft SQL
T-SQL Challenge: Find Days of the Week
My personal goal is to post an article every Monday, Wednesday and Friday. What I’d like to do is create stubs in my content database with each of those days already set aside. That way, I can look at the next stub available and simply start writing. The challenge for...
dba
Incomplete Tables
One of the things I’ve noticed while performance tuning is many of the tables in my current environment are incomplete. They all have columns defined, and
microsoft sql
SQL 201 – Combining Query Results
Overview There comes a point in your SQL career where you will need to combine the results of several queries into one data set, and present it in one view.
microsoft sql
SQL 101 – JOIN
Overview I want to cover a fundamental topic for SQL programming. This is the topic you should start studying right after you have a basic understanding of
microsoft sql
SQL 201 – Sub Queries
Sub queries or nested queries are complete queries wrapped inside of another complete query. Some times this technique is used as a replacement for a JOIN
microsoft sql
SQL 101 – GROUP BY
Consider the following table, orders. buyer productName purchaseDate qtyPurchased pricePaid -------------