Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Delete Partition
Add to briefcase

Delete Partition Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Jules Bonnot
Posted Thursday, May 14, 2009 1:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, January 08, 2012 7:33 AM
Points: 374, Visits: 397
i have a table partition on the primary key. It creates daily partitions. How do i delete partitions older than 7 days.

Thanks alot.

Jules

www.sql-library.com
Post #716673
Jules Bonnot
Posted Thursday, May 14, 2009 5:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, January 08, 2012 7:33 AM
Points: 374, Visits: 397
Is my post not clear? Do i need to use switch? or can i explicitly drop partitions?

www.sql-library.com
Post #716782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.