SQL Server Performance

Partition Management

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by MrVision, Jul 14, 2011.

  1. MrVision New Member

    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??
  2. satya Moderator

Share This Page