The best way to manipulate data within SQL Server is through the use of set-based operations. However, as humans, we tend to think about data in a more row-by-row way. It’s true that Oracle uses a construct called a cursor to facilitate rapid data access. It’s not the same in SQL Server. When accessing data using cursors within SQL Server, row by row can be one of the slowest ways to work with data. Jeff Moden has famously called this type of processing “ree-bar”, abbreviated ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_1818. Row-by-Row Processing from Cursors and Other Causes
Grant Fritchey1
(1)
Grafton, MA, USA
Get SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
