Error!
Success!

MSSQL - Bulk Deleting rows with backup

0
kicks

MSSQL - Bulk Deleting rows with backup  (Unpublished)

Something that is a common problem in mssql server is deleting a very large number of rows from a table. Normally due to locking the table that the very long delete is running on. There is a few common ways of doing this. Mostly by setting row count and looping though a delete until it runs out of rows to delete. In sql server 2008 it is also possible todo this by moving the data from one table to another using a delete and the output clause.


Kicked By:
Drop Kicked By: