SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed

preview_player
Показать описание
In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required with new Intelligent Query Processing scenarios and Query Store enhancements.

00:00 Introduction
00:54 Query Store and Intelligent Query Processing
01:42 Intelligent Query Processing (IQP) NextGen
03:26 Parameter Sensitive Plan Optimization
04:40 Demo
10:55 The pain of MAXDOP
11:34 DOP feedback architecture
12:47 Summary

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #SQLServer2022
  1. Microsoft Developer
  2. Azure
  3. Microsoft
  4. Tech
  5. Technology
  6. Dev
Рекомендации по теме
SQL Server 2022: 0:13:40

SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed

SQL Server 2022: 0:11:13

SQL Server 2022: Introducing SQL Server 2022 General Availability [Ep. 1] | Data Exposed

SQL Server 2022 1:00:40

SQL Server 2022 Intelligent Query Processing new Features

Intelligent Query Processing 0:18:11

Intelligent Query Processing in SQL Server 2022 Preview (Ep.3) | Data Exposed

Introduction to SQL 0:13:33

Introduction to SQL Server 2022 Preview (Ep.1) | Data Exposed

Built-in Intelligence with 0:50:13

Built-in Intelligence with Azure SQL and SQL Server 2022

SQL Server 2022: 0:13:11

SQL Server 2022: Accelerate query performance while reducing query compile time - w/ no code changes

SQL Server 2022 0:13:58

SQL Server 2022 | Faster Querying & Cloud Failover

Performance Tuning In 0:04:40

Performance Tuning In MS SQL Server | Real Time MS SQL DBA Issues Part1

Build Announcements: SQL 0:16:37

Build Announcements: SQL Server 2022 public preview and Azure SQL updates | Data Exposed

Writing your first 0:04:13

Writing your first SQL queries in SQL Server

SQL Server 2022 0:17:52

SQL Server 2022 Preview Storage Engine Capabilities (Ep. 4) | Data Exposed

What's new in 0:13:29

What's new in SQL Server 2022

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

SQL Server 2022 0:50:26

SQL Server 2022 Performance Enhancements

Create SQL User 0:01:18

Create SQL User in SQL Server 2022 Database using SSMS

Microsoft Power BI 0:02:38

Microsoft Power BI | How to get data from SQL server? | Tutorialspoint

Quick Tutorial - 0:07:36

Quick Tutorial - Creating a View in SQL Server

SQL Server Performance 4:03:27

SQL Server Performance Essentials – Full Course

Built-In SQL Server 1:16:11

Built-In SQL Server Tools Make Query Tuning Easier - Week 6

Configuring SQL Server 0:30:23

Configuring SQL Server For Better Performance

Talking about cloud-connected 0:01:00

Talking about cloud-connected scenarios with SQL Server 2022 to build a hybrid solution

Welcome to SQL 1:00:39

Welcome to SQL Server 2022 Live! | Data Exposed Live

SQL Server 2022 0:48:10

SQL Server 2022 - the most Azure-enabled SQL Server yet

Комментарии
Автор

I'm a very firm believer in the sage advice that "One good test is worth a thousand expert opinions", which can also be comically but properly expressed by the movie title of "Show Me the Money"! The very short but pertinent and well executed demo in this 'tube was perfect for the point. Thank you very much for taking the time to put that together and thank you both and your support crew for what you're doing in this series.

jeffmoden
Автор

This is a great demo showing the new IGP features. Can’t wait to test it out and see the difference in our system once we upgrade to SQL Server 2022. Thank you!

mihirtanna
Автор

Thank you very much for the video, great. Is this option available in SQL Azure Management Instance? thanks. Willy

Guille