Archive for the ‘MSSQL’ Category

Deleting batch of rows from MS-SQL Server table




Deleting large number of rows from a (SQL Server) table can cause replication delay, create a very large transaction and a big performance impact, as well as escalating locks so that the table will be unavailable. If it is possible use truncate: TRUNCATE TABLE MyTable; Truncate will run much faster although it has no facility […]