Video unavailable

SQLBits 2022

Looping Abreast

How to combine loops and set-based statements for difficult problems.

There are problems that are difficult to express entirely set-based with set-based code and we have to resort to loops. Say that we need to make such a computation for every customer. Does this mean that we must also loop over the customers? No, in this short presentation I will discuss how we can combine set-based and loops for best performance.

Speaker

Erland Sommarskog is an independent consultant from Stockholm. He has been working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has held the award since.

Erland Sommarskog's Sessions

Analysing and Resolving Deadlocks.

Ask the Expert - Group A (Thu 14:10 to 15:00)

Don’t Let Your Permissions Be Hijacked!

Collations and Performance

Don't Bite Off More than You Can Chew - Take it in Chunks

How sp_sqltrace Can Help with Your Performance Troubleshooting

Looping Abreast

Some Things You May Want to Know About Collations

SQL Titbits for the Inexperienced

Packaging Permissions in Stored Procedures

Dynamic Search Conditions