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

Content with tag Fragmentation Rss

   Items 1 to 20 of 32    Older >>
 

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 | 507 reads

Index Fragmentation

By Steve Jones 2015/03/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,695 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,334 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,516 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,793 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

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,516 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,703 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,334 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

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,301 reads

No Significant Fragmentation? Look Closer…

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.  Read more...
By Additional Articles 2012/03/14 | Category: fragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 2,988 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,697 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,703 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,484 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,703 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,484 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,297 reads

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.  Read more...
By Additional Articles 2010/02/26 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,165 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,703 reads
   Items 1 to 20 of 32    Older >>
 
Tags
indexing (15)    
administration (4)    
defragment (2)    
maintenance (2)    
rebuild (2)    
reindex (2)    
sql server 2005 (2)    
sql server 2008 (2)    
all (1)    
autogrow (1)    
automated index defragmentation script (1)    
custom index defragmentation (1)    
databases (1)    
datafiles (1)    
defragmentation (1)    
files (1)    
frag (1)    
logfiles (1)    
powershell (1)    
rand() (1)    
rebuild index script (1)    
rebuild indexes (1)    
reorganize (1)    
reorganize indexes (1)    
stats (1)    
testing (1)