Drive.  Right now, it's...

Hello Jeff, I came across your presentation while researching the evils of using GUIDs as PKs and to say it was very informative would be an understatement. Do you...

Did you ever find the solution? If so, would you be kind...

Be carefuller - What happens when the number is not part of that plan?

All phone number in the UK start...

Haha... Just like you've done before...

https://www.sqlservercentral.com/forums/topic/hierachy-by-tsql#post-4093618

Heh... Ok... since you brought it up, what prompt(s) did you use?

The key here is, again, the folks answering the questions shouldn't have to...

I worked with one company that stored phone numbers as integers. Yes. Plural. They broke up the 10-character US phone numbers into separate AreaCode (first 3 digits), Exchange (Next...

"On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably...

If the original input string is necessarily an NVARCHAR(anything), then DelimitedSplit8K is probably the wrong tool to use because it will slaughter certain NVARCHAR characters in the conversion to VARCHAR.

Where...

Ok... good.

1. What is populating the [D_ID]?  A SEQUENCE?

You have nullable columns and, because you have PAGE compression turned on, almost all of the columns (even the supposed fixed size...

And yet it's still absolutely stupid about certain "simple" things...  In the example below, this is NOT the right way to solve the given problem.  Even the note...

Pretty cool, @steve-2.

Hello Gurus,

How I am in need of all databases growth in 10 instance and send the report by an email. What's the best way to accomplish such task. If...

Never do reorganize.  On large tables it will take forever and on small tables why reorganize when you can just rebuild.  Treat all your server maintenance like a man...

The real trouble is most likely the way that someone is concatenating the string.  Post the code doing the concatenation and we can probably confirm the issue and, if so,...