Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

Design Patterns Session

Posted on January 2, 2012January 25, 2012 by slowder

Brazil_flag

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.
    • Create Troubled Table T-SQl Script — This contains the table we’ll use for our examples.
    • Manually Deleting Stinks!
    • De-duping by temp table — an overview
    • De-duping by temp table— a deeper dive
    • De-duping by Self join
    • De-duping by CTE
  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 Cancel reply

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

  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme