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

Scripts with tag Fragmentation Rss

Search for any content tagged fragmentation

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 15 of 15   
 

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,687 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,217 reads

SQL Server Index Defragmentation (Updated)

Defrags all indexes in select databases in 2005, 2008, and 2012.  Read more...
By Gregory Ferdinandsen 2014/02/07 | Source: SQLServerCentral.com | Category: admin
Rating: |  Discuss |   Briefcase | 3,227 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,293 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,619 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,247 reads

Index Defragmentation

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...
Rating: |  Discuss |   Briefcase | 11,371 reads

Index Fragmentation for All Databases

Returns Top 25 fragmented indexes complete with full object name and index name.  Read more...
By Jon Morisi 2011/04/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,374 reads

Reindex SQL Tables

This stored procedure will reindex indexes based on the fragmentation lever.  Read more...
By Balbir Singh 2009/05/14 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,896 reads

2008 Index Fragmentation Maintenance

Just a stab at automating index maintainenance in SQL Server 2008  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 2,494 reads

Are disk volumes fragmented on server? Does it require to be defragged

Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.  Read more...
By Bhavesh-257515 2008/10/24 | Source: SQLServerCentral.com | Category: fragmentation
Rating: (not yet rated) |  Discuss |   Briefcase | 733 reads

Checking fragmented indexes

A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.  Read more...
By Gaby Abed 2008/09/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,165 reads

Check Fragmentation on All Indexes on Database

In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %   Read more...
By Augusto Alfonso 2008/09/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,300 reads

INDEX DEFRAG on SQL SERVER 2005

Defrag all indexes in a database for SQL Server 2005  Read more...
By Scott Dexter 2008/08/05 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,390 reads

SQL Server 2008 index fragmentation

Script to see how fragmented the indexes are.  Read more...
By BarryK 2008/05/15 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 3,039 reads
   Items 1 to 15 of 15