• Interests: Photographie, Korfbal, Playing Music

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

814 reads

Blogs

Daily Coping 23 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Read the latest Blogs

Forums

Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

By Vladimir Isaev

We have this ad hoc query that is a recurring block leader, blocking dozens...

ADD Values from a table to an another table

By LD3060

I am working with Microsoft SQL Server MANAGMENT STUDIO 18  and i Have 2...

In-Place upgrade from SQL Server 2016 to SQL Server 2019 leaves older version

By ericwenger1

My company has decided that in-place upgrading to SQL Server 2019 for test environments...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers