• Interests: Photographie, Korfbal, Playing Music

Technical Article

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 28 Oct 2021

By

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

The DBA as a helpdesk.

By

Every one and again you will see people asking What skill do you think...

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Update table FirstName & LastName from Email addresses

By DaveBriCam

I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...

SQL Instance Aliases - Urgent assistance needed please

By Brandie Tarvin

I have a migration problem. I cannot get my SQL Server instance aliases to...

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers