Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.  Read more...

Display multiple rows values as single row value in different rows (No Cursor).  Read more...

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...

Fill a specified partition of a table with a specific query, working on staging table   Read more...

This script helps with the truncate Table Partition command in SQL Server  Read more...

Rebuilds online a table partition with all indexes   Read more...

Read more...

S partitions from the ground up, with advice on binding, merging, and selecting partition data.   Read more...

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...

for huge data insertion and deletion by avoiding locking you can use partition tables.  Read more...

Sample script for Table Partition  Read more...

In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.  Read more...