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 Pedro Lopes MS,
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
EDIT: Statements are shown in results pane because of need to properly indent the output code.
EDIT2: Added check for redundant indexes, so dba can opt out of creating them.
EDIT3: Wrong drop statements fixed.
Referencing indexes in a SQL statement
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegrou...
Automatic indexing while appending
Generate create statements for missing FK indexes, based on DRI
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered ...