SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, Rebuild Rss

   Items 1 to 7 of 7   
 

Rebuild All Indexes in a Database (Tables/Views)

This script rebuilds all indexes in a selected database (tables and indexed views). Ifm you have a very large Database with many indexes and indexed views please consider before you run this script it might take a while to run. I myself run it around once a month after new data comes my way  Read more...
By Angel Rapallo 2016/09/28 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 657 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,350 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,191 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,350 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,350 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,438 reads

Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.  Read more...
By Kimberly Killian 2011/09/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,431 reads
   Items 1 to 7 of 7   
 
Tags
fragmentation (2)    
administration (1)    
all (1)    
databases (1)    
frag (1)    
maintenance (1)    
rebuild indexes (1)    
reorganize (1)    
reorganize indexes (1)    
table (1)    
view (1)