Partition Management | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Partition Management

There 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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |