Changes to Query Plans

YouTube·PASS Data Community Summit

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.