Tag: sql server

Community

Understanding Hash Joins

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that the smaller of the two inputs is the build input. Hash joins are used for many types of set-matching operations: inner join; left, right, and full outer join; left and right semi-join; i

Community

Auditing with SQL Profiler

(Brian Kelley) The first time I touched SQL Profiler was to find out what long running queries were hammering a particular database. That was the moment I fell in love with this tool. I’ve used it to find stored procedure recompiles, infinite program loops on the client-side, and other performance n