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 «««1234

Keeping my cardinality Expand / Collapse
Author
Message
Posted Tuesday, April 29, 2014 6:42 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 1,794, Visits: 779
Nice question -

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1566187
Posted Tuesday, April 29, 2014 11:32 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
paul s-306273 (4/29/2014)
Looks like I'm going to learn something everyday this week.
Thanks for the 2014 questions Steve.


+1


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1566209
Posted Tuesday, April 29, 2014 11:58 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:25 AM
Points: 2,489, Visits: 770
PHYData DBA (4/29/2014)
You are absolutely right about that this was not an answer that could be selected. Not sure it would be right. The question never states if the database existed prior to the upgrade. It could have been there before, or created after.

Reworded question gives a hint like it was existing database:
a specific database where I am not changing any code

I such case if you wanted to use new CE for the entire database then changing compatibility level to 120 comes right. For old CE nothing is needed.
Post #1566212
Posted Wednesday, April 30, 2014 5:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:45 AM
Points: 7,860, Visits: 9,606
dawryn (4/29/2014)
Is this question about previously existing database or a newly created one? According to linked document answers are only for the latter


He has a point there. The question says you've upgraded your server, and it's a database which already exists. The upgrade process will leave this dabase's compatability level at 110 specifically in order to avoid any surprises from the new cardinality estimator, and you are advised (on the page referenced as well as in SQL Server 2014’s new cardinality estimator (Part 1)) to test thoroughly before using the new cardinality estimator for an old database in production. So the correct answer to this question is actually "do nothing - you'll get the old cardinality estimator for your old databases anyway".

edit: at least the question says you aren't changing any code in that database, which seems to me to imply it already exists.


Tom
Post #1566332
Posted Wednesday, April 30, 2014 3:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 6,098, Visits: 8,367
I know this is nitpicking, but "change the database compatibility level to 110" is not really a correct answer. The question mentions upgrading, and the uograde process will not change the compatibility level. So the technically correct answer would be "don't do anything, and especially don't increase the compatibility level".


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1566611
Posted Wednesday, April 30, 2014 6:48 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
nice question steve.
Post #1566629
Posted Thursday, May 1, 2014 10:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,284, Visits: 15,748
I hate questions.


I've awarded back points (finally), and changed the question to note that after the upgrade, all databases were set to 120.

I'm open to other ways to work this and get the point across. Obviously I've failed somewhat here.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1566773
Posted Tuesday, May 6, 2014 4:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
free_mascot (4/29/2014)
paul s-306273 (4/29/2014)
Looks like I'm going to learn something everyday this week.
Thanks for the 2014 questions Steve.


+1

+1


Thanks
Post #1567869
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse