Strings and Defaults

Question

Post reply

Strings and Defaults

Gail Shaw

SSC Guru

Points: 1004504
More actions
January 25, 2012 at 8:17 pm

#251978

Comments posted to this topic are about the item Strings and Defaults
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Viewing 15 posts - 1 through 15 (of 47 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Good question - thanks for reminding me of the basics

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Paul White SSC Guru Points: 150467 More actions · Answer 2

Backwards compatibility has a lot to answer for. I cringe slightly every time I see a variable-length data type used without an explicit maximum length value.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Easy one, thanks Gail!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 4

bitbucket-25253 (1/25/2012)
Good question - thanks for reminding me of the basics

+1

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Iulian -207023

SSCertifiable

Points: 7639

January 26, 2012 at 12:56 am

#1438596

Thanks for the question

Iulian

Brigadur SSCrazy Points: 2097 More actions · Answer 6

Good question, thanks. It is good to be reminded of the default length issues.

Cheers

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

SQL Kiwi (1/25/2012)
Backwards compatibility has a lot to answer for. I cringe slightly every time I see a variable-length data type used without an explicit maximum length value.

Only slightly?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Cadavre SSC-Forever Points: 41690 More actions · Answer 8

Wow, wasn't aware of this so thanks (went with 1 and 1).

Good job I always specify length so it hasn't cropped up before

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

paul s-306273 SSChampion Points: 10730 More actions · Answer 9

paul s-306273

SSChampion

Points: 10730

January 26, 2012 at 2:13 am

#1438616

Good reminder of these sorts of issues.

Thanks Gail.

Paul White SSC Guru Points: 150467 More actions · Answer 10

GilaMonster (1/26/2012)
SQL Kiwi (1/25/2012)
Backwards compatibility has a lot to answer for. I cringe slightly every time I see a variable-length data type used without an explicit maximum length value.
Only slightly?

I am practicing the art of understatement.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

LuciaNewbie Grasshopper Points: 19 More actions · Answer 11

LuciaNewbie

Grasshopper

Points: 19

January 26, 2012 at 2:49 am

#1438632

Good question.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 12

I thought such a basic question, which has appeared numerous times in the QotD, would have been easier, but apparently more than 50% - at the moment - still got it wrong. :blink:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 13

good question!!!

thanks Gail!!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 14

Thanks for the question

Always a good reminder now and then.