Are U a part of the Sql Community ?
Tuesday, May 27th, 2008Are U a part of the Sql Community ?
Are you part of the Sql Community ?? If not join here. A highly recommended website for Database developers.
Posts Tagged ‘SQL Server’
SQL Server 2005 Partition Management
Tuesday, January 29th, 2008SQL Server 2005 Partition Management
Sliding Widnow technique is commonly used with partitioned tables to manage large data volumes. It allows efficient loading of new data and archival or removal of the old data. The challenges in a sliding window scenario is to create the staging table(s) correctly for efficient partition SWITCH operations. This utility provides a command line interface to:
1. Remove all the data from one partition by switching it out to a staging table. It creates the required staging table.
2. Create a staging table for loading data into a partition. The staging table can be created with or without indexes — if created without indexes this utility provides a separate command to create appropriate indexes on the staging table, before SWITCHing it into the partitioned table.
The commands can be invoked from other scripts for end-to-end sliding window scenarios.
