sp_QuickieStore: Time Zones, Time Zones, Time Zones
In this video, I delve into the intricacies of working with Query Store data in SQL Server, specifically addressing a significant oversight where query store data is stored in UTC but searches are not. I explain how SP_QuickieStore was developed to correct this issue by displaying all query store dates in your local time and allowing accurate searching through UTC times. The video explores the challenges of accurately passing date and time parameters without offsets, detailing why using 'sysDateTimeOffset' is crucial for precise searches. I also highlight the importance of understanding time zones and how to use the 'help' parameter within SP_QuickieStore for troubleshooting and learning purposes.
CHAPTERS
00:00:00 - Introduction to Query Store Timezone Issues
00:03:25 - Explanation of Stored Procedure SP_QuickieStore
00:07:08 - Importance of Using UTC for Accurate Searches
00:10:06 - How to Search Through Query Store with Correct Timezone Parameters
00:14:08 - Use of sys.timezoneinfo DMV for Validating Time Zones
00:15:03 - SP_QuickieStore Functionality and Benefits
00:16:14 - Conclusion and Thank You
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━