SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


CHOOSE - 1


CHOOSE - 1

Author
Message
davoscollective
davoscollective
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1008
Christian Buettner-167247 (1/29/2013)
bitbucket-25253 (1/29/2013)
davoscollective
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

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.
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)

Group: General Forum Members
Points: 66341 Visits: 18570
Thanks Ron.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Ken Wymore
Ken Wymore
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6577 Visits: 2396
Thanks for the question.
jfgoude
jfgoude
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1458 Visits: 299
without running code how can you predict such answer ?
I have neither SQL2012 nor adventureworks2012

I had better to play lotto !
sqlcentral-bugmenot
sqlcentral-bugmenot
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 39
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.
-1
malleswarareddy_m
malleswarareddy_m
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2739 Visits: 1189
i did not like the question because of insufficient information was provided.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search