T-SQL Shortcomings With Merge And Triggers And Stuff (In SQL Server)

In this video, I delve into the intricacies of merge statements, triggers, and output in T-SQL, highlighting how they interplay but often fall short due to their limitations. I discuss how improvements like action columns for triggers and the ability for regular insert, update, and delete operations to reference source and target tables would greatly enhance developer productivity and make working with these constructs much more straightforward. By referencing Aaron Bertrand's insightful posts and Michael J. Swart's advice on merge usage, along with an example involving a simple table and trigger, I illustrate the current challenges developers face and advocate for T-SQL modernization to better meet their needs in today's evolving landscape of database technologies. CHAPTERS 00:00:00 - Introduction 00:02:15 - T-SQL Improvements Needed 00:04:08 - Merge and Triggers Example 00:06:00 - Annoyances with Merge Output 00:08:01 - Why Merge is Special 00:09:43 - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY SQL Server Performance Engineering Course https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING Learn T-SQL with Erik https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL Everything Bundle: https://training.erikdarling.com/?coupon=SPRINGCLEANING ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlconsulting ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member https://www.youtube.com/@ErikDarlingData/join ━━━━━━━━━━━━━━━━━━━━━━━━━━