Design Patterns Session


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!

2 Comments on "Design Patterns Session"

Leave a Reply

Your email address will not be published. Required fields are marked *