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

Content with tag online Rss

   Items 1 to 3 of 3   

Rebuilding SQL Server indexes using the ONLINE option

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.  Read more...
By Additional Articles 2012/02/08 | Source: | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,935 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: | Category: data warehousing
Rating: |  Discuss |   Briefcase | 731 reads

Rebuild partition

Rebuilds online a table partition with all indexes  
By Federico Iori 2010/03/12 | Source: | Category: rebuild
Rating: |  Discuss |   Briefcase | 1,762 reads
   Items 1 to 3 of 3   
data warehousing (2)    
partition (2)    
defragmentation (1)    
etl (1)    
indexing (1)    
parallel (1)    
populate (1)    
rebuild (1)    
very large table (1)