Category Archives: All Articles

In a SQL Server there is two things Blocking and Locking. Today will check about blocking. There are number of ways to find out the details of the system processes IDs (spids) involved in blocking. I have tried to cover some of the options in this tip to include: sp_who2 System Stored Procedure The sp_who2Continue reading “Identify Block SPs”

Whenever SQL Server needs to perform a query execution additional following Transact-SQL statements are executed: 1) FROM 2) WHERE 3) GROUP BY 4) HAVING 5) SELECT 6) ORDER BY 7) LIMIT We will be give more details about above conditional clauses in next blog…