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

2007-10-02 (first published: )

50,065 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

What Are You Waiting For?

By Laura Copeland

Comments posted to this topic are about the item What Are You Waiting For?

BCA Finance Bekasi Layanan Mobil Tlpn/Wa:6285188120691

By josephmerry54

KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...

BCA Finance WTC Mangga Dua Tlpn/Wa:6285188120691

By josephmerry54

Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers