kermitforney
Technical User
Is there anyway to search table.column statistics in SQL Server for detailed insight while optimizing indexes?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index Opt. Table Statistics 1
- Thread starter kermitforney
- Start date
- Status
-
1
- #2
I think I follow your question.
I like to use SQL traces create by SQL Profiler. You can capture a trace then load it into DTA (Database Tuning Advisor). DTA will then give you some nice reports showing table/column/sp usage.
-If it ain't broke, break it and make it better.
I like to use SQL traces create by SQL Profiler. You can capture a trace then load it into DTA (Database Tuning Advisor). DTA will then give you some nice reports showing table/column/sp usage.
-If it ain't broke, break it and make it better.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question