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: Thursday, July 23, 2015 11:19 AM
Points: 91, Visits: 22
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, June 4, 2015 12:41 PM
Points: 3,278, Visits: 1,307
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:21 PM
Points: 2,077, Visits: 597
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, February 24, 2015 8:11 AM
Points: 194, Visits: 70
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, June 4, 2015 12:41 PM
Points: 3,278, Visits: 1,307
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