Clinton Herring


SQLServerCentral Article

Replacing Cursors and While Loops

Get some big performance gains by removing cursors from your code. New author Clinton Herring brings us a couple hints as he shows how two cursors were replaced in his code, resulting in 80 minutes of processing time dropping to 12!

(7)

You rated this post out of 5. Change rating

2006-04-07 (first published: )

50,072 reads

Blogs

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Fulltext filter daemon host (FDHost) process has stopped abnormally

By zoggling

We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...

Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer

By Cláudio Tereso

Comments posted to this topic are about the item Automating OSM Data Refresh in...

Database Mail Configuration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mail Configuration

Visit the forum

Question of the Day

Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL,  how can I do so?

See possible answers