Viewing 15 posts - 466 through 480 (of 59,063 total)
Hi, I' am currently in the process of designing the Data Warehouse spec for my company (Start up Business),
During discussions a number of the technical leads and C# developers...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 13, 2024 at 7:40 pm
Jeff Moden wrote:With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh!
will you drive or fly Jeff 😀
Drive. Right now, it's...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 13, 2024 at 3:02 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 13, 2024 at 1:42 pm
disregard. i found it. I'll reply w/ what i end up with to close the loop
Did you ever find the solution? If so, would you be kind...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 5:29 pm
Ah... be careful now. That's absolutely not possible.
Be carefuller - What happens when the number is not part of that plan?
All phone number in the UK start...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 5:20 pm
Haha how do I do that?
In an attachment?
Haha... Just like you've done before...
https://www.sqlservercentral.com/forums/topic/hierachy-by-tsql#post-4093618
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 5:17 pm
Here you are courtesy of ChatGPT
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 5:13 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 2:29 pm
"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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2024 at 2:27 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2024 at 5:47 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2024 at 5:39 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2024 at 7:02 am
Pretty cool, @steve-2.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2024 at 6:19 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2024 at 6:03 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2024 at 5:53 am
Viewing 15 posts - 466 through 480 (of 59,063 total)