Technical Article

Deleting Sets of Rows in huge table

There was a problema user was reflecting http://groups.yahoo.com/group/sqlcon/message/1119What I did was following steps1. Divide the count of table into segments for divide2. Then use the even Odd functionality for smooth looping3. Use a simple while loop and SET ROWCOUNT functionality for further deletions across table with checkpoint4. It saved the log swell up and resources […]

2005-07-20 (first published: )

251 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

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

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Identity Insert

By erics44

hopefully a quick one This tsql SET IDENTITY_INSERT dbo.tblSCVMatchedv3 ON insert into dbo.tblSCVMatchedv3 select...

SET STATISTICS equivalent

By DamianC

Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers