On the Journey to be a SQL Server Professional
SQL Server Administration, Development and B.I. Development related
How to delete records in chunk to avoid blocking?
SET
NOCOUNT
ON
WHILE
1
=
1
BEGIN
DELETE
TOP
(
1000
)
FROM
YourTable
WHERE
FilterConditions
END
Newer Post
Older Post
Home