Viewing 15 posts - 61 through 75 (of 59,038 total)
In my quick look at your article this morning, I may have missed it... are you using the paid version for ChatGPT?
April 2, 2025 at 1:54 pm
I love how people tip-toe around this subject. Oh... it's not going to eliminate DBA jobs... we'll just be able to get along with 3 people instead of 5 to...
March 31, 2025 at 3:27 am
If you're going to start talking about Random GUIDs (uniqueIdentifier type not using NEWSEQUENTIALIUD()), then you absolutely MUST watch the following video, which proves that what most people think they...
March 31, 2025 at 1:31 am
I wonder what the "compute cost" of these new functions is?
March 28, 2025 at 11:14 pm
Thanks for your comments. I understand your points and I would like to clarify a couple of things.
Regarding the execution time difference, batch updates are faster because they reduce...
March 27, 2025 at 1:01 am
uhm, what about "Temporal tables"?
"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.
So drop...
March 24, 2025 at 5:25 pm
To be honest, I'd delete the REORGANIZE job and disable the REBUILD job. Microsoft finally took down the 5/30 supposed "Best Practices" on 20 April 2021 and a lot of...
March 24, 2025 at 5:20 pm
Add that user to the "model" db -- with whatever permissions you want -- and they will automatically be added to every new db.
Ditto that.
March 20, 2025 at 1:59 pm
While I do have an appreciation for anyone that steps up to share information, there are a couple of serious problems with the supposed "Practical Use Cases" in the article...
First,...
March 19, 2025 at 4:31 pm
Humm... I couldn't get it to work. You gave: 'USE ? select DB_NAME(DB_ID(''?''))
But I don't know the database name. The server has many databases. I want to search all...
March 17, 2025 at 4:10 am
It could be anything. Did they switch domains that one of the machines was on? Did they add any new switches or routers or make any "settings changes". We had...
March 17, 2025 at 4:06 am
I'm curious... what does the lowest level of management think of what you said. Has anyone even told them? And how about the next level or two above that? Have...
March 13, 2025 at 1:45 am
Just to say it out loud... It's very likely that I'll never post anything on GitHub. However... a lot of companies insist that if you're not adding to GitHub on...
March 12, 2025 at 9:33 pm
Never mind about me thinking they were talking about "Jump" tables. I'm not a DW kind of person.
I asked Perplexity.AI the following...
What is a "junk" dimension in a data warehouse?...
March 12, 2025 at 8:31 pm
Viewing 15 posts - 61 through 75 (of 59,038 total)