2025-09-03
1,912 reads
2025-09-03
1,912 reads
We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."
2016-09-09 (first published: 2015-06-01)
13,569 reads
Exploring some differences between using cursors, local fast forward cursors and using set logic.
2016-11-11 (first published: 2015-02-03)
17,332 reads
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.
2014-06-02
7,057 reads
In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.
2012-09-28 (first published: 2011-03-21)
34,383 reads
Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.
2010-09-01
5,122 reads
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
42,814 reads
Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.
2009-03-19
5,627 reads
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
23,264 reads
2010-06-23 (first published: 2008-12-24)
37,400 reads
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
Comments posted to this topic are about the item SQL Server Ghosts