Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Cardinality Regression Expand / Collapse
Author
Message
Posted Monday, June 2, 2014 12:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:26 PM
Points: 91, Visits: 13
On May 15th the question of the day was similar, but it was about forcing the new cardinality on a db w/ the compat mode set at 100, and the correct answer was to use the trace flag 2312, not sure how now the correct answer can be that's the flag used for forcing the old cardinality?
Post #1576694
Posted Wednesday, June 4, 2014 7:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 25, 2014 2:58 PM
Points: 3,173, Visits: 1,267
Please update this QOTD

The documentation now states.

you can run the query with trace flag 2312 to use version 120 (the new version) of the cardinality estimator



Post #1577323
Posted Monday, June 9, 2014 10:01 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
good question thanks steve.
Post #1578897
Posted Wednesday, June 11, 2014 5:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:03 AM
Points: 194, Visits: 65
In my opinion, Its not a Feature, ist a bug and fixed asap
Post #1579576
Posted Wednesday, June 11, 2014 8:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 25, 2014 2:58 PM
Points: 3,173, Visits: 1,267
I just tested this on my 2014 server and this is what I observed

Running a query with trace flag 2312 will use version 120 (the new version) of the cardinality estimator when the database compatibility is 110 (SQL 2012)

Running a query with trace flag 9481 will use version 70 (the old version) of the cardinality estimator when the database compatibility is 120 (SQL 2014)



Post #1579661
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse