Viewing 15 posts - 61 through 75 (of 59,058 total)
I'm hoping that the errors in your attached script aren't going to matter... also, the code you posted above doesn't run due to all of the errors in that.
Msg...
May 6, 2025 at 12:42 am
No... it's not "feature" complete. First, I don't know what they heck they did to it but there was a massive slowdown when 2019 came out and it's still slow...
April 28, 2025 at 12:58 am
How in the heck does something like this get past QA?
From what I've seen over the years with SPs, CUs, and new releases, I'm starting to thing that...
April 24, 2025 at 9:20 pm
The "Used but Unallocated Space" is usually because of a "wonderful" feature known as "Fast Inserts". It is meant to provide a performance gain when doing inserts containing a huge...
April 24, 2025 at 9:18 pm
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...
April 23, 2025 at 5:48 pm
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
Yes... especially due...
April 23, 2025 at 5:26 pm
It's the middle of the night and I'm online for "reasons."
Looking at your link, Jeff, somebody didn't proofread their code or didn't care. Samples 1 & 4 are identical...
April 17, 2025 at 10:19 pm
Plagarism , not cool.
Just to still make a note. I find the ISO_week property interesting.
select datepart(iso_week, '2025-03-30') select datepart(week, '2025-03-30')
Maybe we need an article on this topic.
It's the same...
April 15, 2025 at 8:49 pm
Hi,
Need this DAX covert SQL T-SQL.
Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitted Date]), MINUTE([Remedy Submitted Date]),
SECOND([Remedy Submitted Date])) RETURN SWITCH( TRUE(), TimeOnly < TIME(13, 0, 0), "Prior...
April 15, 2025 at 8:37 pm
When would you say it's ok in just about any kine of business where it's OK for dates and times to round up to the day, week, month, quarter, or...
April 15, 2025 at 8:19 pm
My function by default returns all matches, but you have options to prioritize fewer rows matching or more rows matching.
So post it.
April 15, 2025 at 8:16 pm
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
It's not...
April 15, 2025 at 8:07 pm
My favorite "Edge Case" is in the conversion of a DATETIME2 with a given resolution to a DATETIME2 of lower resolution or even DATETIME. When is it "OK" for the...
April 15, 2025 at 7:52 pm
It would appear that most of the code has simply been stolen from the following article...
April 14, 2025 at 9:34 pm
Lordy... I missed your post above, Ron. Great tip. Thanks for posting it and sorry for it taking me nearly two years to acknowledge it.
To add to your good information,...
April 13, 2025 at 2:31 pm
Viewing 15 posts - 61 through 75 (of 59,058 total)