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 30    Older >>
 

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,220 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,204 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,676 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

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,204 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,354 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,220 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,290 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,270 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,916 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,612 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,354 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,371 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,354 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,371 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,243 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,104 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,354 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,354 reads

Keep Your SQL Server Indexes Fragmentation Free

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.  Read more...
By Additional Articles 2009/09/22 | Source: DevX | Category: indexing
Rating:  Rate this |   Briefcase | 5,003 reads
   Items 1 to 20 of 30    Older >>
 
Tags
indexing (14)    
administration (2)    
defragment (2)    
maintenance (2)    
rebuild (2)    
reindex (2)    
sql server 2005 (2)    
sql server 2008 (2)    
admin (1)    
all (1)    
automated index defragmentation script (1)    
custom index defragmentation (1)    
databases (1)    
defragmentation (1)    
frag (1)    
powershell (1)    
rand() (1)    
rebuild index script (1)    
rebuild indexes (1)    
reorganize (1)    
reorganize indexes (1)    
stats (1)    
testing (1)