Changes to Query Plans

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Learn about two significant changes in SQL Server 2014 that impact query plans, especially for data warehousing applications, in this 56-minute conference talk. Discover how to manage statistics on large tables using the new partition-level stats definition and update capability. Explore the redesigned cardinality estimator that influences plan costing. Delve into the reasons behind these changes and understand their potential effects on your database performance.

Syllabus

24 Hours of PASS: Changes to Query Plans

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube