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: )

254 reads

Blogs

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans

By

There are quite a few different ways that you’re likely to see window functions...

Exploring Windows Function Execution Plans

By

There are quite a few different ways that you’re likely to see windows functions...

Read the latest Blogs

Forums

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers