August 5, 2010 at 2:23 am
We have a very huge table in Development Database.
So Each night, we want to delete data from this table in small batches.
Here are the specs:
•The job should start at midnight and should stop at 6:00 AM.
•It should delete rows from the table in batches of no more than 100. We may have to reduce this number to be certain there aren't blocking issues on the target side of replication.
August 5, 2010 at 6:03 am
SET ROWCOUNT 100
Delete from TableName
🙂
August 5, 2010 at 9:06 am
Do you want to delete all of the data?
If so take a look at truncate table.
August 5, 2010 at 9:47 am
harry79 (8/5/2010)
We have a very huge table in Development Database.So Each night, we want to delete data from this table in small batches.
Here are the specs:
•The job should start at midnight and should stop at 6:00 AM.
•It should delete rows from the table in batches of no more than 100. We may have to reduce this number to be certain there aren't blocking issues on the target side of replication.
Do you have any specific questions?
August 5, 2010 at 3:16 pm
This is a duplicate of this post http://www.sqlservercentral.com/Forums/Topic964054-391-1.aspx, which is where I answered the question. I'm not going to duplicate my post here, but I am going to edit my post on the other thread point any another posters to this thread since there are more posts here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 5, 2010 at 5:04 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply