Do you really need all those DISTINCT statements? Shouldn't the one that fills the temporary tables do the job for the ones that follow? Each of those requires aggregation. Also,...

The deal with shrinking databases is not the simple act of a one-time shrink:

"Oops, we had a bad data load. Gotta shrink the database."

Despite the dire warnings you get all...

You may have to restore to a new database and then migrate the data over manually or using a tool.

Personally, I'd say it's 70/30. We had a balanced budget...

We also watch Miracle on 34th Street, with Natalie Wood, Maureen O'Hara, John Payne and Edmund Gwenn, in black and white (the best way to watch it). Note: Edmund...

Yep. All done. Sucks.

They are only going to affect the query if there is blocking. If there is a lock over on resource X and you're accessing resource Y, it doesn't matter. It's...

And for reference, here's the documentation on synonyms.

Ah, so you're not after locks as such, you're looking for blocking and what's causing the blocking?

If so, here is a great article on exactly how to do that.

One thing that few consider is that it might be "recompiles".  We had a query that was taking "only" (way too long in my eyes) 100ms to execute.  The...

First, you'll need to detail exactly what it is you're hoping to see, which events you're capturing and how what you want for filtering.

Second, just so you know, Profiler has...

You'll see tons of variation on the duration even if every other thing about the query is identical, the rows returned, the parameter values used, everything exactly the same. Why?...

The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing the...

In addition to what Jeff says, be carefule when you say things like "similar execution plans". Similar is not the same as identical. Small differences in an execution plan can...

The duration only includes the time that the query ran on the server. It doesn't include any transfer times or waits at the start of execution.