sys.dm_tran_locks is going to have the locking information, although I'm not sure if it will show lock escalation as it occurs. Once you're in there, you can get the sessionID...

When in doubt about thing released by Microsoft, the best source is Microsoft. You can go to the MSDN web site. Finding "What's New in SQL Server 2005 SP3" will...

It sounds like parameter sniffing (do a search on that phrase for volumes of information).

But, statements like this in your WHERE clause

abs(abs(a.value)-abs(b.value)) >= @threshold

Are going to prevent index use in...

The very nature of SQL Server is try to make it possible for lots of people to read the same data at the same time. Reading data, not updating/deleting it,...

There used to be several tools available for reading log files. I know that Idera had one as did Red Gate. I'm pretty sure Red Gate's is gone. I'm not...

Yeah, it was the number of plan guides that you'd need that made me balk. You can create a plan guide for an ad hoc query, but any variation in...

Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?

I can't read minds, but I can see the future...

I see... I see... a dba-wanna-be on the street, looking for work... I...

Bare, bare, bare minimum, run sp_who2 to see if you have blocked processes. From there, you need to delve into all the skills of troubleshooting and investigation. Without at least...

I started out using various nicknames, but when I published my first article with Steve, he asked me to change my nickname to my real name... and so it has...

Actually, though... thinking about it. I'm not sure you could make a plan guide work. Hmmm... that might be tough.

You can using a hint, but since this is ad hoc (right?) you'll need to use a plan guide.

Excellent.

So you are using forced parameterization then?

The different plans from the web is probably, but not definately, because of differences in the type of connection or settings within the connection. If you drill down on all...

GSquared (6/9/2009)

Okay, Steve. Normally I back you up when you have typos in articles and someone...