Skip to content

Design Patterns Session

2012 January 2
by Shannon Lowder


On February 6, I’m going to tele-present a session on T-SQL design patterns to the Brazil SQL Server Users Group.  During this session I’ll cover three common scenarios you face, that can be solved by using T-SQL:

  1. Removing duplicate rows from tables.
  2. Upserts — handling updates and inserts at the same time.
  3. improve performance by replacing cursors

Over the next few posts I’m going to share an expanded view of that session.  I’ll include test data, all my code samples, and a deeper look at the execution plans for the different code samples.   As I build these posts, this page will become an index page.  I’ll also include a recording of the session!

As always, if you have any questions about the content, please let me know!

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS