Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Fragmentation Rss

   Items 1 to 20 of 35    Older >>
 

Adaptative Files Autogrow

Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases  Read more...
By Samuel HERVOUET 2016/01/07 | Source: SQLServerCentral.com | Category: files
Rating: |  Discuss |   Briefcase | 999 reads

SQL Server Heaps, and Their Fragmentation

In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary? Neeraj Tripathi explains.  Read more...
By Additional Articles 2015/11/23 | Source: SimpleTalk | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 3,199 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 | 5,193 reads

Adaptative Files Autogrow

Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases  Read more...
By Samuel HERVOUET 2016/01/07 | Source: SQLServerCentral.com | Category: files
Rating: |  Discuss |   Briefcase | 999 reads

Index Fragmentation

By Steve Jones 2015/03/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,734 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,374 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 | 5,193 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,817 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,525 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 | 5,193 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,827 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,374 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,408 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,308 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 | 3,035 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,729 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,827 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,539 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,827 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,539 reads
   Items 1 to 20 of 35    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)    
heaps (1)    
index rebuilds (1)    
logfiles (1)    
powershell (1)    
rand() (1)    
rebuild index script (1)    
rebuild indexes (1)    
reorganise (1)    
reorganize (1)    
reorganize indexes (1)    
statistics (1)    
stats (1)    
testing (1)