Archive for

Query Execution Plan Red Flags

This post will outline a few of the major areas of an execution plan to pay attention to when analyzing an query execution plan. This is by no means an exhaustive list, as performance issues can arise from thousands of reasons, each with different resolutions. Additionally many of the “red flags” documented here are a … Continue reading

Are Cursors Evil?

We have all been taught the evils of using cursors, but do cursors have a place in our T-SQL arsenal? Are cursors always a bottleneck and is it simply better to replace a cursor with a while loop? Clearly, the performance problems are because the code is not doing things in a set based manner, … Continue reading