There is many ways to get his information; however in most cases you get information for a single table. If you want to get it
Category: Performance Tuning
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
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
Listing blocking chain by tasks
References: #20
Queries execute slow what is the issue?
This is a very loaded question, there is no simple answer. But few things to make sure before you go crazy on PTO, make sure
Performace Tuning Stored Procedures
I been performance tuning an OLTP system which is built with Visual Basic Front end, Microsoft Components middle tier and SQL Server back-end for DBMS.
SQL Canada (SQLCAN) 