Tom Garth (6/1/2010)
I think I almost got it right - :-)
This was a great question that made me do a little reading and learn something about a little understood part of SQL Server.
I do believe that the other 16% who got it right, deserve more than just 2 points.
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Speaking of which, you deserve 2 points for your tag line! :-)
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
"Operator! Give me the number for 911!" - Homer Simpson
"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"