SQL Server Performance Forum – Threads Archive
help!!!!! this is something extrangehello i need some help and sorry for my english… well the problem that i have is when i run a select query a block ocurrs in the db and when run the sp_who to see the speed that is blocking mi query i relaice that it is my speed but i didn’t use transactions. i create temp tables and make updates on these tables an use sub querys into the main query.
You may see the SPID blocking itself if you are on SP4, because it also reports latch waits.
For more info see,
http://support.microsoft.com/default.aspx/kb/906344 Roji. P. Thomas