COMMIT INTERVAL for Delete/Update - by Jorj51

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 725441 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/17/2012 11:29:36 AM
Access Restriction Public

Description

I would like to see the ability to add a commit interval to SQL statements.  This would help large data deletes and updates from filling up the transaction logs.

For example:
DELETE
   FROM some_table
 WHERE column1 = 5
COMMIT INTERVAL 1000

I know that it's possible to to do this using for loops but for loops cause a lot of overhead (slow) and are generally not that efficient and generally look messy in code.
Sign in to post a comment.
Posted by Microsoft on 2/24/2012 at 3:43 PM
Hello,
Thanks for your feedback. We don't have any plans to extend DML statement to specify such physical characteristics. It doesn't belong in the declarative language. If we start adding such options the UPDATE/DELETE syntax will get complicated & we have to provide whole bunch of options.
So given the priority of this request with respect to others in our pipeline, I am closing this as Won't Fix.

--
Umachandar, SQL Programmability Team