Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Indexing Rss

Search for any content tagged indexing

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 20 of 173    Older >>
 

Index stats with key,included columns, size - all you can eat

Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition  Read more...
By Doran Mackay 2016/02/04 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 767 reads

Complete Index Detail

Complete index analisys  Read more...
By Leonardo Campos 2014/11/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,840 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 598 reads

Index rename to standards

Rename indexes according to pattern: IX_<TableName>_<Col1>_<Col2>.. or AK_<TableName>_<Col1>_<Col2>..  Read more...
By Renato Buda 2014/10/06 | Source: SQLServerCentral.com | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 979 reads

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,573 reads

Reindex Procedure with a Twist (or two) the SQL

A 2012 update to "Reindex Procedure with a Twist (or two)":   Read more...
By Keith Hays 2015/09/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,152 reads

All Index Size

All Index Size  Read more...
By mkl-1013783 2014/06/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,093 reads

Reorganize indexes

Generate script to reorganize indexes in a database  Read more...
By Andrés Michaca 2014/05/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,409 reads

Generate script to rebuild indexes in a database

Generate script for reconstgruir ena database indexes  Read more...
By Andrés Michaca 2014/04/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,640 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,128 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 2015/03/27 | Source: SQLServerCentral.com | Category: foreign key list
Rating: |  Discuss |   Briefcase | 3,850 reads

Total space used per table

I have received some comments on getting total space of table and all indexes. Therefore I rewrote previous query and it returns total space used, space used by heap table or clustered index and space used by non-clustered indexes.  Read more...
By Louis Li 2015/02/23 | Source: SQLServerCentral.com | Category: table space
Rating: |  Discuss |   Briefcase | 3,066 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2015/12/31 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,653 reads

Unique Identifier as Clustered index

This script selects clustered indexes containing only a uniqueidentifier column  Read more...
By Wilfred van Dijk 2013/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,171 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: indexing
Rating: |  Discuss |   Briefcase | 1,582 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 2015/03/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,024 reads

Reindexing for fragmented indexes

Script will give you the list of fragemented indexes. (For SQL 2005-2008)  Read more...
By Rahul 2013/06/21 | Source: SQLServerCentral.com | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,823 reads

Reorganize indexes for all tables in all user databases

Script to reorganize all indexes on all tables in user databases  Read more...
By Harsha Majety 2013/02/14 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,581 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: indexing
Rating: |  Discuss |   Briefcase | 2,007 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,695 reads
   Items 1 to 20 of 173    Older >>