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??

   MrVision, Jul 14, 2011

   #1
2. satya Moderator

   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

   satya, Jul 15, 2011

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in