Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 159    Older >>
 

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 2014/07/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,695 reads

All Index Size

All Index Size  Read more...
By mkl-1013783 2014/06/18 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 592 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,060 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,325 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 970 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,662 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,444 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,532 reads

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.  Read more...
By Tim Parker 2012/11/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,270 reads

Script for no of Index in a table

This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.  Read more...
By Thava 2012/11/23 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 857 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2013/12/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,152 reads

Defragment all indexes on Database

It finds the Indexes on database which needs to be Defragmented and Rebuilds those indexes. Only you need to replace 'database_name' with your database.   Read more...
By Jignesh Patel 2012/08/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,082 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,560 reads

Defrag All Indexes On a Database

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.   Read more...
By Hakim Ali 2012/05/25 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,280 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,441 reads

Index Defragmentation (2005, 2008, 2012)

Complete script for index defragmentation and updating stats  Read more...
By Gregory Ferdinandsen 2012/01/02 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,602 reads

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...
By SQLSACT 2011/08/30 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 704 reads

Reindex - Reorganize or Rebuild

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.   Read more...
By Benes Guislandi 2011/08/10 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,271 reads

Finding all Columns of an Index

This script helps to find all columns of an index on a table. Include columns covered (include)  Read more...
By Augusto Alfonso 2011/06/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,268 reads

Index Defragmentation and update stats

A thorough SP for rebuilding indexes.  Read more...
By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,235 reads
   Items 1 to 20 of 159    Older >>