DBCC (Transact-SQL) Overview

SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…

A DBCC PAGE Example with Output

This post will demonstrate how to run the undocumented DBCC PAGE command to view the properties of a page. First we execute the…

The the most blocked queries

Views – 572

Find resource currently involved in blocking

Views – 540

T-SQL for identifying slow-running queries on a database

Views – 575

Using sp_WhoIsActive

Here is an awesome extentions of the sp_who and sp_who2 (undocumented) sprocs DBA’s use to see slow running queries etc. Download link for…