• 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

813 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Buy Dumps , Dumps With Pin Shop , Buy Dumps With Pin Online Fast And Easy 2021

By mikenco52

Visit my Shop to Buy Dumps , Dumps With Pin , CVV2 , CCV...

LEGIT CVV DUMPS WITH PIN SHOP ONLINE 2021

By mikenco52

SHOPDUMPS101.ONLINE Legit Dumps With Pin Shop Online 2021 - Buy Dumps With Pin Fresh...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers