Not sure if it helps explain the confusion or not, but I initially thought that top 1000 was an incorrect answer becasue it was the one I selected and I...

Other than the example given in the answer, where the set rowcount is turned on, what would be the situation where the top 1000 in a 10000 row table would...

From WIKI -

This causal determinism has a direct relationship with predictability. (Perfect) predictability implies strict determinism, but lack of predictability does not necessarily imply lack of determinism. Limitations on...

Try it this way:

Create Table #Temp

(

UniqueColumn UNIQUEIDENTIFIER DEFAULT NEWID(), Val int

)

Insert Into #Temp (val) values(1)

Insert Into #Temp (val) values(2)

Insert Into #Temp (val) values(3)

Insert...

The question is a quote from the Microsoft documentation. but has a second purpose here. See the article written by two Microsoft researchers. http://msdn.microsoft.com/en-us/library/cc441928.aspx

Based on the...

Since SQL Server 2005 did not have Page Compression (as I know it), it wasn't too much of a jump to know this was about 2008 and not 2005. ...

Excellent question.

You gotta do it by highlighting the object name possibly surrounded by double quotes (if of the form schema.object e.g. "dbo.tableX" ) in a query window for it to work....

Was that weird or what!

Awesome syntax!

That one shines Nick. Probably one of the best queries ever written.

Possibly trite but finding the sense of humor on these questions can be as adverse as some of the toughest questions. I comment when right and for obvious reasons,...

If my meaning was that it was intended to be a trick question, then...

The concept isn't wrong, but a bit too broad. Cursors being cursors,...

I expected to get this wrong. What a surprise when I saw that STATIC is correct. Then I noticed it was Hugo who posted the question. ...