05:39How SQL is getting smarter – Intelligent Query Processing 2017 to Today | Data Exposed
From the creator
Did you know that SQL has built in query intelligence on par with other “autonomous” systems? Did you know that SQL can adjust and adapt to your workload over time to give you the best available performance without any user action? SQL has been investing in this space for the past 3 major versions – today, we walk through those investments to explain the impact of these investments in our query processing components. 00:22 - Introductions 01:06 - What is Intelligent Processing 02:06 - SQL Server or Azure Feature? 02:40 - Overview of IQP "Family Tree" Timeline 13:45 - How should we think about these improvements 14:50 - It just runs faster 15:05 - Closing ✔️ Resources: https://learn.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer
Published 2023-08-03 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
