microsoft sql

microsoft sql

Comparing Query Performance

A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks

microsoft sql

SQL101-Homework Assignment #2 Answer Key

Here are my answers to the questions based on AdventureWorks. I recently updated the answers to work with the 2008R2 version of Adventureworks. If your

SQL101

SQL101-Homework Assignment #2

SELECT with JOIN Here are a few more problems to practice with. Again, practice these queries against a copy of AdventureWorks. Now we're going to start

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

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

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