SQL Server Performance

Sets Aren't Always the Answer

Discussion in 'EditorsBlog' started by shanetasker, Dec 15, 2008.

  1. shanetasker New Member

    I was reading the blog post 'There is a limit to set based solutions' today and it got me thinking about some of the patterns and practices that we follow. The problem with any set of rules is that the rules do not always fit every possible scenario and are just a general guide. The issue with following rules is that many people blindly follow the advice of others without understanding why. I am sure that most people reading this are aware that in many scenarios a set based solution will achieve better performance than a procedural based solution. However, often we follow this advice without considering that there are exceptions to the rule or possibly other alternatives. When was the last time you tested a set based solution against a procedural solution to see if the procedural solution was really slower?
    - Peter Ward

Share This Page