Wow. I'm amazed that runs in 54 seconds.

Without reading every single line, the one thing I'm noticing is, you don't really have the concept of JOINS down. Take this:

SELECT ID...

All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.

Just because the connections are from the same SSMS instance doesn't mean they have the same settings. One of those connections is showing what I consider normal color coding on...

See, you might get to 80 tables too.

Glad you found it.

You do need to be very careful about using table variables. But, if you're dealing with very small data sets that would be scanned anyway, regardless of statistics, then table...

Interesting question... I'm not sure it'll help, but you can get the actual logical and physical reads by query for the queries that are in cache using sys.dm_exec_query_stats. Generally I...

We once had a query that was joining 80 tables. It took about two minutes to recompile and, because of the nature of the data, it was recompiling about every...

Yep. 'post' is not a number.

You have to inlcude a mechanism for eliminating duplicate games. Is it the first one encountered? The first one alphabetically? The one with the lowest or highest ID number? You...

Let's have a war

We can start it in New Jersey

We don't

really

need all these people

in the city

There's too many of us, there's too many of us, there's too many of...

A primary key and the index created in support of it are basically one and the same. Management Studio creates all the primary keys, by default, as the clustered index....

There can be only one!

Now back to writing about backup encryption.

Excellent. Consider it borrowed. I'm working on the first draft of a review process for PASS and the new SQL Standard so I'll incorporate this. It's actually not too far...

I'm glad it helped. Understand though, it really is introductory. You're going to blow past it pretty quick. Come back and post when you have questions on details as you...

I'm aligned with those who don't see a special l33t forum for invited users, not that I'd get invited. Anything I'm going to post, especially questions when I have them,...