This post is a continuation of the SQL Server 2014 Cardinality Estimator enhancements exploration series: A first look at the query_optimizer_estimate_cardinality XE event “CSelCalcCombineFilters_ExponentialBackoff” Calculator “CSelCalcCombineFilters_ExponentialBackoff” Calculator– Part II The CSelCalcAscendingKeyFilter Calculator Cardinality Estimation Model Version Comparing Root-Level Skews in the new Cardinality Estimator Using Legacy Methods to Lessen SQL Server 2014 Cardinality Estimator Skews […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
Troubleshooting the new Cardinality Estimator
Posted on: December 29, 2013 3:42 pm
Non-Join Cross-Table Predicate Correlation Changes
Posted on: December 20, 2013 8:30 am
This post is a continuation of the SQL Server 2014 Cardinality Estimator enhancements exploration series: A first look at the query_optimizer_estimate_cardinality XE event “CSelCalcCombineFilters_ExponentialBackoff” Calculator “CSelCalcCombineFilters_ExponentialBackoff” Calculator– Part II The CSelCalcAscendingKeyFilter Calculator Cardinality Estimation Model Version Comparing Root-Level Skews in the new Cardinality Estimator Using Legacy Methods to Lessen SQL Server 2014 Cardinality Estimator Skews […]
More on Exponential Backoff
Posted on: December 19, 2013 1:26 pm
This post is a continuation of the SQL Server 2014 Cardinality Estimator enhancements exploration series: A first look at the query_optimizer_estimate_cardinality XE event “CSelCalcCombineFilters_ExponentialBackoff” Calculator “CSelCalcCombineFilters_ExponentialBackoff” Calculator– Part II The CSelCalcAscendingKeyFilter Calculator Cardinality Estimation Model Version Comparing Root-Level Skews in the new Cardinality Estimator Using Legacy Methods to Lessen SQL Server 2014 Cardinality Estimator Skews […]
New Course: “SQL Server: Database Creation, Configuration, and Alteration”
Posted on: December 17, 2013 8:37 am
Today Pluralsight published my new course, “SQL Server: Database Creation, Configuration, and Alteration”. This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups. Areas I cover include: How to create a database How to configure files and filegroups Configuration of file settings Configuration […]
