help!!!!! this is something extrange | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

help!!!!! this is something extrange

hello 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
http://toponewithties.blogspot.com
]]>