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 – 495

Find resource currently involved in blocking

Views – 461

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

Views – 496

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…