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:
- 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
- Upserts — handling updates and inserts at the same time.
- 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!