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.
- 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!