Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 7, 1999

Deletion Problem

Question:
Is there an option to set deletion without getting logged? I have to delete two years of historical data but would like to keep this year's data on my 80MB of rows. I created a new table for this year's data and I truncated the old table. Is there a better way to do this?

Answer:
Unfortunately, there is no way to have a delete statement operate as an unlogged operation. So your way is fine.

As you've realized, deleting a year's worth of data at once is not a simple task. If I did have to delete many records, I would break it up into smaller operations. So perhaps I would delete records for each month or week at a time. In this way, the Server won't check by being asked to affect millions of rows in one operation.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date