The less loopy the better! I have been using tally tables for a couple of years now but this article really expanded my understanding of how the technique can be applied more broadly. An excellent article – great post Ted! If you still use a lot of loops or cursors in your TSQL code you’re out of touch with best practices. Tally tables, CTE’s (common table expressions), MERGE and “update X” statements are well established methods to convert loops to set based operations and are fundamental skills expected of mid-level TSQL developers. If you don’t have these in your repertoire now, do some reading and find ways to apply these techniques in your very next TSQL coding assignment.

Advertisements

About tim.edlund

Tim Edlund founded Softworks Group Inc. in 1990. As CEO, Tim is responsible for setting strategy and leading product R&D. Tim has maintained expertise in database technologies and is an Agile methodology evangelist. He also enjoys staying fit , skiing and trying to survive parenting teenagers.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s