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

807 reads

Blogs

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Removing ad hoc plans from Query Store

By

This is not a post about the “optimize for ad hoc workloads” setting on...

Read the latest Blogs

Forums

Needed to find all possible Dates Overlaps from a single Table

By Hell-1934

Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...

Optimize Cursor

By GrassHopper

I inherited this script that has a cursor and I know this query can...

Unable to add secondary node existing node due to DCOM is unavaialble

By maroju1

Dear Team, This is Naveen, Hope all are doing well. I need emergency help...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers