Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Wilfred van Dijk,
create this view in a database, select * from index_usage.
reports #hits compared to #updates (as ratio)
statement to disable index also included.
Make sure you understand the index/database concepts before making descisions based on the output of this script !
NOTE: If you get strange errors when running this script, some stange characters might be added when pasting this script into the web
index include script
Generate scripts for all indexes in a database
INDEX NAME, TAble Name, Index Script.
scripts indexes database
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the pos...