Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

deleting data from partitioned table Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 3:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, March 14, 2014 3:58 PM
Points: 82, Visits: 440
We have a table that is currently partitioned on a date column. The data has been copied to a warehouse and we would like to delete the data from the table since we do not need two copies. We are planning on just dropping the partitions instead of running delete statements. Are there any gotchas that we need to be aware of before moving forward with this strategy?

Thanks in advance.



Post #1357035
Posted Tuesday, September 11, 2012 1:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 10:03 AM
Points: 1,256, Visits: 1,758
Shouldn't be any problems but tested in Dev first.

Alex S
Post #1357676
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse