Viewing 15 posts - 91 through 105 (of 39,466 total)
If you look at the code I posted, the text to describe what happens says that "When the fractional precision of the datetime2(n) value is greater than three digits,...
April 21, 2025 at 4:47 pm
I doubt Windows will lose 1/2 share as a laptop OS.
As a mobile device OS, yes, as I think iOS/Android and tablets are more and more common for many people....
April 21, 2025 at 4:44 pm
select *
from a inner join b on a.x = b.x collation latin_ci_ai
inner join c on b.y = c.y collation latin_cs_ai
April 21, 2025 at 4:42 pm
Apologies, my typo. It is UDP 1434
Points awarded back
April 17, 2025 at 8:30 am
Hi all,
Our approach is quite rigid: all components (web sites, services) must first be taken offline, then any upgrade scripts are applied to the database, then the components are...
April 16, 2025 at 7:49 am
I would prefer DB first because getting the data model right is something that will serve the business functionality well for years and probably serve many generations of applications,...
April 16, 2025 at 7:48 am
Call me a dinosaur if you like, but I'm 100% with Alex Gay - don't use it and wouldn't use it for code I can write myself. Nearest...
April 16, 2025 at 7:45 am
Awfully Infuriating
Amazing and Idiotic
Assistance Included
April 10, 2025 at 2:26 pm
This sounds like something doable, but likely something that is done outside of T-SQL. I only see a few dbatools replication commands, but for something like this, which is a...
April 9, 2025 at 7:18 pm
Good points. As the only DBA in a few places, I haven't had a ton to do after the first 6 months when I clean up the environment. In those...
April 9, 2025 at 7:16 pm
Short answer, ID10T error.
Longer answer, I was editing this as we had a formatting problem and I think I changed the answer here and then changed the question, without testing....
April 9, 2025 at 7:14 pm
I see some SSIS people moving to ADF, but mostly just running SSIS from the connector.
Some non MSSQL people seem to like dbt, but that looks like a wild, crazy...
April 8, 2025 at 6:55 pm
I think this is an Azure size. What do you want to change? Cores or RAM?
April 8, 2025 at 6:53 pm
I would lean towards DesNorton's solution as I dislike triggers and I think they get hidden/lost from future devs/DBAs.
April 8, 2025 at 6:53 pm
The sizes are here: https://learn.microsoft.com/en-us/azure/virtual-machines/sizes/general-purpose/ddv4-series?tabs=sizebasic
You have a 64 core, 256GB ram machine, correct? What do you want to grow? Cores? RAM? CPU generation? This page might give you some...
April 8, 2025 at 6:20 pm
Viewing 15 posts - 91 through 105 (of 39,466 total)