Understanding Query Cache and Query Plans
2008TL; DR
Understanding Query Cache and Query Plans
Session Details
SQL Server 2005 introduced new types of Query Plans and how Query Plans can be used as query hints.
In this session we will do a deep-dive into Query Plans, looking at how Query Plans are stored and how to interpret Query Plans. We will also look at different system management vies who can help developers and DBA's to better understand what goes on with query plans and subsequently write better performing queries.
3 things you'll get out of this session
Speakers
Niels Berglund's previous sessions
Analyze Billions of Rows of Data in Real-Time Using Azure Data Explorer
In this demo-filled session we get an overview of Azure Data Explorer, which is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. We look at how to ingest data, as well as query in real-time against billions of rows with sub-second latency.
ksqlDB - The Real-Time Streaming Database
In this demo filled session we see how we use ksqlDB to gain real-time insights into streaming data. We look at push/pull queries, User Defined Functions, tables and streams.
Set Your SQL Server Data Free with the Use of Kafka
In this talk we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.