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

Adapatative Files Autogrow

Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases  Read more...
By Samuel HERVOUET 2015/07/08 | Source: SQLServerCentral.com | Category: files
Rating: |  Discuss |   Briefcase | 521 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,794 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2015/09/04 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,557 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: administration
Rating: |  Discuss |   Briefcase | 3,336 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,382 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,700 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,298 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,711 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,485 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,914 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,516 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 | 760 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,263 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,353 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,399 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,139 reads
   Items 1 to 16 of 16