Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Cardinality Estimates Rss

   Items 1 to 4 of 4   
 

Cardinality Regression

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

Upgrading cardinality

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

Keeping my cardinality

By Steve Jones 2014/04/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 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,068 reads
   Items 1 to 4 of 4   
 
Tags
administration (3)    
sql server 2014 (3)    
performance (2)