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!

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.


Leave a comment

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