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»»

T-sql Expand / Collapse
Author
Message
Posted Friday, December 17, 2010 5:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:36 PM
Points: 1,786, Visits: 1,116
I agree that this questions been asked many times, but it is good to have this kind of generic question because there will be new members who want to learn every little piece of SQL Server. Good question.
Post #1036469
Posted Friday, December 17, 2010 6:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 8:17 AM
Points: 2,917, Visits: 2,537
Rahul The Dba

Welcome to the forum. Good question. Many will complain about simplicity or the number of times that this type of question has been asked, but it is also good to refresh on even the simplest of things.


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #1036495
Posted Friday, December 17, 2010 7:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:50 PM
Points: 7,924, Visits: 9,649
Nice simple question.

The wrong answer rate suggests that even something as straightforward as this has some instructional value.


Tom
Post #1036512
Posted Friday, December 17, 2010 9:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
DougieCow (12/17/2010)
Toreador (12/17/2010)
How many times do we have to have questions about the default precision of strings before everyone gets them right?!


Never, there will always be somebody new.



I agree Dougie.
Also, if you have submitted a question you know that as long as it takes for one to be published there is a high chance that someone else will post something covering the same topic.

As far as the answers go, I almost selected the 'HI YO' answer cause I thought it was funny.

Thanks for the easy point on a friday and some giggle factor in the answers.
Post #1036609
Posted Friday, December 17, 2010 9:35 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Tom.Thomson (12/17/2010)
Nice simple question.

The wrong answer rate suggests that even something as straightforward as this has some instructional value.


I agree. Maybe it should be asked several more times.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1036612
Posted Friday, December 17, 2010 9:37 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 10, 2014 4:59 AM
Points: 127, Visits: 133
THANKS FOR ALL YOUR POSTS.....

Rahul
Post #1036614
Posted Friday, December 17, 2010 11:53 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 9:31 AM
Points: 717, Visits: 3,037
The only reason I got this right is that there was a QoD some weeks back that had a default data length as part of the question. I got that one wrong.

I was taught to never rely on defaults for things like declaring variables, so out-of-sight, out-of-mind. I'd quite forgotten they existed.

Anyway, thanks for letting me know I learned something from that earlier QoD!
Rich
Post #1036680
Posted Friday, December 17, 2010 2:22 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question!

I'm still surprised by 9% of the people getting it wrong, so I guess it doesn't hurt to go over the same thing multiple times.
Post #1036760
Posted Sunday, December 19, 2010 9:28 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Simple one. 15% wrong answers are there b'cos few of them just select what ever they want to without even looking at question
Post #1037014
Posted Tuesday, December 21, 2010 2:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
I like the question, mostly because it focuses on one aspect only - the default size.
Too many times there are complicated questions which mix the question itself with ostacles and obfuscations. I then prefer repeated questions over complicated questions.

Thanks!


Best Regards,
Chris Büttner
Post #1037569
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse