References: #21 Statement copied from The Rambling DBA: Jonathan Kehayias Blog
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Get Top 50 SQL Statements/Query Plans
Finding out what statements causing grief on SQL Server has become significantly easier with SQL Server 2005+. I am using some of the DMV/DMF to
1st Month at Microsoft…
FAST! I promise to not turn this into a personal blog and will start posting SQL related stuff again *soon*; just need to get my
Microsoft Community Contributor Award
Heh, Just got the 2011 Microsoft Community Contributor award. Yeeh. Got pretty badges and certificate :D. Thanks!! PS I just like to add, posts on
Microsoft SQL Server Associate PFE
So where have I been? Sorry for no posts, or other updates of sort. I been busy a bit since July; I tried to get
Getting Index count for all tables
Davide Mauri wrote a nice script, I have done similar work without using CTE. So I really liked the script; I notice in his comments
SQL Canada (SQLCAN) 