Performance

External Article

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  • Article

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.

2018-06-26

2,974 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

MSSQL Service Broker DSQL operation on another database causing Broker failure

By andyewx

I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers