I suspect using OPEN TABLE is the issue. If you go out & bounce around in Google, there are a lot of people experiencing problems with it. I couldn't find...

Mohit (3/9/2009)

---

Hey ..

People here on SSC are great in helping, but when posting such large SQL code blog. It makes it difficult for them to help you....

I am...

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.