Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Cardinality Estimates Rss

   Items 1 to 5 of 5   
 

Bad Cardinality Estimates from SSMS Plans – Redux

Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,549 reads

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,361 reads

Upgrading cardinality

By Steve Jones 2014/05/15 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,419 reads

Keeping my cardinality

By Steve Jones 2014/04/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,679 reads

Fixing Gatekeeper Row Cardinality Estimate Issues

The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator in order to select the best query plan from the most likely alternatives. Sometimes these estimates can go so wildly wrong as to result in a very slow query. Joe Sack shows how it can happen with SQL Queries on a data warehouse with a star schema.  Read more...
By Additional Articles 2012/12/10 | Source: SimpleTalk | Category: cardinality estimates
Rating:  Rate this |   Briefcase | 1,122 reads
   Items 1 to 5 of 5   
 
Tags
administration (3)    
sql server 2014 (3)    
performance (2)    
plan explorer (1)