Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Indexes Rss

Search for any content tagged indexes

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)

Add a script

   Items 1 to 6 of 6   
 

Yet another way to defrag indexes

A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.  Read more...
By Gaby Abed 2014/07/25 | Source: SQLServerCentral.com | Category: defragmentation
Rating: |  Discuss |   Briefcase | 1,270 reads

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...
By Martin Collazos 2014/02/18 | Source: SQLServerCentral.com | Category: foreign key list
Rating: |  Discuss |   Briefcase | 1,769 reads

Find the size of all Indexes in a database

This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.  Read more...
By Bodhisatya Mookherjee 2013/10/15 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,480 reads

Script out/store all indexes on a server

This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.  Read more...
By MyDoggieJessie 2013/09/03 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,196 reads

Script to Rebuild/Reorganise Indexes

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...
By Andrew Pruski 2013/02/19 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,839 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,392 reads
   Items 1 to 6 of 6