Learn T-SQL With Erik: AT TIME ZONE Performance
In this video, I delve into the often frustrating world of AT TIME ZONE performance in SQL Server, sharing my personal experience and strong dislike for dealing with time zones. I highlight common pitfalls, such as performing date math directly on AT TIME ZONE columns, which can severely impact server performance. By comparing query plans and execution times, I demonstrate why it's better to handle time zone conversions carefully, using functions like 'SWITCHOFFSET' to maintain data integrity while optimizing query performance. If you're dealing with similar challenges or just want to improve your understanding of SQL Server time zones, this video is packed with valuable insights and practical advice. CHAPTERS 00:00:00 - Introduction 00:01:48 - Timezone Performance Issues 00:03:59 - Query Plan Analysis and Data Types 00:06:27 - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ FREE SQL SERVER MONITORING & Plan Analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━ https://github.com/erikdarlingdata/PerformanceMonitor https://github.com/erikdarlingdata/PerformanceStudio https://plans.erikdarling.com/ ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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