SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

3
kudos

Kudos

Kevin Kline : Why Do I Keep Seeing This Mistake?

posted by

sa 1031 days, 3 hours, 27 minutes ago

Kevin Kline : Why Do I Keep Seeing This Mistake?

One of the fundamentals of loop optimization is that you should move stable operations outside of the loop. What I want to know is - if this is such a fundamental rule, why do so many people break it?!?

If you are familiar with other programming languages, then you are probably aware of loop optimization techniques. You should try to put all operations outside of the loop if they don’t need to change within the loop. This reduces the amount of unnecessary repetitive work. SQL Server optimizer doesn’t...