• 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

Getting Started with Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

How SQL Server stores data types: DATETIMEOFFSET

By

If you’d like to check out the previous instalment in this series on storing...

Daily Coping 16 Jun 2021

By

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

Read the latest Blogs

Forums

Help with Boolean check box combinations

By Hogie503

Hi SQL Experts, I have a Store Procedure with snippets of code listed below....

https://bigshop79.com/ Online dumps shop - Dumps track 1 and 2 with pin - Dumps

By bossgold

contad admin icq : 683485306 gmail : bossgold63@gmail.com  sell dumps transfer

https://bigshop79.com/ SELL DUMPS TRACK1/2 - SELL CC FRESH - SELL USA FULLZ VERI

By bossgold

contad admin icq : 683485306 gmail : bossgold63@gmail.com sell banktransfer sell ccv

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers