SSIS Merge with Duplicate Rows

The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...

ALTER AUTHORIZATION sql to change owner of a database

ALTER AUTHORIZATION changes the ownership of  entities .  Server level entity ownership can be changed to server- level principals. Database level...

24 Hours of PASS Questions

I finally found the time to work through the questions from the 24 Hours of PASS session that I did....

Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may have to rethink one of the answers given during...

Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may...

How Should We Pay People?

It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some...

KB2463332 failed to install

This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...

Missing indexes

One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....

NOT IN or IN?

I have been having a hard time believing my eyes when I noticed that these queries give different results:

1. select...

September 2011 SQL Server 2008 Instance Level Diagnostic Queries

Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...