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 […]

You rated this post out of 5. Change rating

2005-07-20 (first published: )

255 reads

Blogs

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Advice I Like: Take Two Trips

By

If you have any doubt about being able to carry a load in one...

Read the latest Blogs

Forums

Is there an ISERROR equivalent in SS?

By water490

Hi everyone I have a SP that just failed.  Format of SP is: Select...

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers