Viewing 15 posts - 17,236 through 17,250 (of 22,206 total)
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...
June 10, 2009 at 7:16 am
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...
June 10, 2009 at 7:09 am
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...
June 10, 2009 at 7:01 am
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,...
June 10, 2009 at 6:51 am
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...
June 10, 2009 at 6:44 am
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...
June 10, 2009 at 6:25 am
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
June 10, 2009 at 6:15 am
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
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...
June 10, 2009 at 6:07 am
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...
June 10, 2009 at 6:06 am
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...
June 9, 2009 at 11:25 am
Actually, though... thinking about it. I'm not sure you could make a plan guide work. Hmmm... that might be tough.
June 9, 2009 at 9:10 am
You can using a hint, but since this is ad hoc (right?) you'll need to use a plan guide.
June 9, 2009 at 9:09 am
Excellent.
So you are using forced parameterization then?
June 9, 2009 at 8:44 am
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...
June 9, 2009 at 8:31 am
GSquared (6/9/2009)
Steve Jones - Editor (6/8/2009)
Back from SQLSaturday #14 in Pensacola, what did I mess?
Okay, Steve. Normally I back you up when you have typos in articles and someone...
June 9, 2009 at 8:23 am
Viewing 15 posts - 17,236 through 17,250 (of 22,206 total)