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…

Keeping Indexes online while reindexing

This will also display the SQL Statement that is the offending blocker. Online index operations: Online index operations were added as an availability…

Adding SELECT Excel hyperlinks to recordsets

Users frequently want spreadsheets with embedded links to web pages, one per row. This is one way to get them.

Views –…

Getting the plan handle for a sproc

You can use this T-SQL to get the plan handle for a sproc that has a bad execution plan:

Make sure, to…

Viewing the execution plan for a specific Sproc

Views – 722