• 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

815 reads

Blogs

Why You Need Presentation Skills

By

And no, the answer is not because you want to be a Microsoft MVP....

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Read the latest Blogs

Forums

PASS Data Community Summit

By cindygross

Who's going to PASS Data Community Summit this year? It's been quite a while...

SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process

By Surendra Kumar Reddy Koduru

In this Article I’m going to demonstrate the heterogenous systems integration and building the...

Get addresses that match list of customers

By Jackie Lowery

Let's say i have a table with columns:  cus_no, address, city, state, zip. How...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers