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

CHOOSE - 1 Expand / Collapse
Posted Wednesday, January 30, 2013 3:55 PM



Group: General Forum Members
Last Login: 2 days ago @ 4:24 AM
Points: 495, Visits: 895
Christian Buettner-167247 (1/29/2013)
bitbucket-25253 (1/29/2013)
A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both the Adventureworks2012 and AdventureworksDW2012 databases. I would have thought this would be something SQL Server professionals should all do so that you can start to become familiar with the new functionality prior to any potential upgrade of your systems, or even just to keep your skills up to date. If not then this question might be useful in that it serves as a prompt to do that. If you can't install stuff at work and you don't want to do it on your off time, then why not get a free cloud trial with Azure or something else so you can try it out. I'm pretty sure I've read Steve Jones suggesting exactly that a few times.

Bolding added by this poster.


1. Deny the problem
2. Blame it on the customer
What does that remind me of? Oh yes, customer service in general...

Don't get me wrong, I honor the fact that you submitted this QOTD (and the many great questions from you before this one, and the ones that are about to come). But I think this one went in the wrong direction.
But maybe I have misinterpreted it. Because I was under the impression that it tries to teach you how to use Choose, not how to become a "SQL Server professional" by reviewing AdventureWorks during QOTDs.

1) I think you've taken me out of context here, that quote is not my entire reply. My first comments were assuming that he had made a mistake in the question and I think it's fair to give him the benefit of the doubt.
2) I don't think you are a customer here considering this is free, it's an opportunity to learn, and if you work in the SQL Server space and are keen on continuous learning then Adventureworks should be very familiar to you. It's the common ground we have to provide examples to each other without revealing sensitive corporate data.

Again, if you can't afford it or don't have the space for 2012 dev/express/MSDN free, get a test account on one of the cloud providers. If you don't have time for that then fair enough, but surely that is your decision, unless of course you are an indentured DBA.
Post #1413790
Posted Monday, February 4, 2013 11:32 AM



Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Thanks Ron.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...


Posting Performance Based Questions - Gail Shaw
Post #1415426
Posted Monday, February 4, 2013 8:37 PM

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: 2 days ago @ 10:56 AM
Points: 3,417, Visits: 2,035
Thanks for the question.
Post #1415561
Posted Friday, February 22, 2013 2:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 3:24 AM
Points: 1,144, Visits: 299
without running code how can you predict such answer ?
I have neither SQL2012 nor adventureworks2012

I had better to play lotto !
Post #1422924
Posted Tuesday, February 26, 2013 7:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 6:04 PM
Points: 32, Visits: 35
This one clearly proved that roughly half the people here do not try to solve the "riddles" using their brain. Without fetching that silly demo, the only correct answer would have been one marked as incorrect - since you'd be forced to add a uniform distribution assumption.
Post #1424070
Posted Friday, April 19, 2013 11:38 AM



Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:09 PM
Points: 1,940, Visits: 1,173
i did not like the question because of insufficient information was provided.

Post #1444548
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse