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, July 16, 2014 7:10 PM
Points: 1,786, Visits: 1,111
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: Monday, July 14, 2014 9:47 AM
Points: 2,919, Visits: 2,525
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 8,559, Visits: 9,054
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,232, 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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 21,217, Visits: 14,920
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
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 11, 2013 3:27 PM
Points: 127, Visits: 132
THANKS FOR ALL YOUR POSTS.....

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


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:01 PM
Points: 687, Visits: 3,002
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: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
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, July 22, 2014 1:45 AM
Points: 2,826, Visits: 3,866
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