Partition Management | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Partition ManagementThere is a theory floating around here that we could create partitions on a very large table (400 million rows, 1 TB data) using a date range and then when the range becomes stale we simply drop the partition and instantly purge blocks of data (25 million rows or so) in 1 fell swoop. I am not seeing this in any tech doc I am reading. Is this possible??
Welcome to the forums.
yes its possible and it is an Enterprise Edition feature so you have to check whether your enviornment supports.
Few references for your study and joy:
http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx and http://www.sqlskills.com/BLOGS/KIMBERLY/category/Partitioning.aspx links