Tag Info

New answers tagged


I previously assumed that SQL Server would only report a blocking session in the blocking_session_id column, if the blocked sessions were waiting for a logical lock and not anything else such as a PAGELATCH_*. You are using Adam Machanic's sp_WhoIsActive procedure, not a built-in SQL Server facility. Adam's procedure reports all 'interesting' causes of ...


This question was actually answered in the comments, however, the following links will provide a good source of knowledge regarding execution plans. From Execution Plan Basics — Hash Match Confusion I found: From http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/ "The hash join is one of the more expensive join ...

Top 50 recent answers are included