Divide big delete into several small ones

Big transactions cause the Tlog to grow.When you do a clean of a large table, the delete statement can cause a very long transactionSometimes it's necessary to prevent this.So we divide one big delete into several little ones.A table with call centre data gets +/- 1-mlj records a day. Every day we run a script […]

2002-08-27

805 reads

Blogs

Why do DBAs dislike loops?

By

If you started out as a developer you were probably taught how important loops...

Public and Demo Data Coming Soon!

By

Any database professional that has been around the Microsoft world for more than about...

New Centralized View of SQL Resources in Azure

By

Yesterday, some new views were made available in the Azure portal that will be...

Read the latest Blogs

Forums

Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3

By iosman123

Hello, I noticed that SQL Server 2005 SP3 is not in the in the...

Can't drop database in "restoring" state from secondary instance of AG

By auaiomrn

MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it...

ReportServer Database upgrade fails

By lmarkum

I've tried several times to successfully  migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers