Viewing 15 posts - 1,921 through 1,935 (of 59,066 total)
I could see a huge potential on the sales side, being confidently incorrect is pretty much the only real requirement for a career in marketing 😛
BWAAA-HAAA-HAAA!!!. Now there's a...
February 10, 2023 at 7:50 pm
I don't know of a windows-driven "interrupt" that would do it (and, if someone does, please fire a flare 'cuz I'l love to know it!) but, if if there was...
February 10, 2023 at 5:01 pm
It's difficult to produce such a list of new functionality even when restricted to just those for T-SQL.
One of my OMG! favorite improvements was when the came out with STRING_AGG()...
February 10, 2023 at 4:43 pm
informaton schema was taking 0 cpu and 0 time.
Uh, huh... It did in my example, as well. You should also do more than one test to see why the...
February 10, 2023 at 4:32 pm
As emphatically strong a suggestion as I can make...
If you get the opportunity to take the all-day class on SQL Server 2022 put on by Bob Ward of Microsoft,...
February 10, 2023 at 4:26 pm
Can we see how "scratch.dbo.DelimitedSplit8K" does the spliting of the string?
Yes. Here's an article that explains how it works and why it's so fast. Don't use the code for...
February 10, 2023 at 4:20 pm
oh god no don't use UNION ALL unless you really need to. Why not just something like this to get all the records you need from each source?
INSERT INTO...
February 10, 2023 at 5:50 am
As I said second option is still used but it's slow. @pietlinden
@jeff Moden: which requires a union all? 😅 , No thx
As opposed to what??? The (in your own...
February 10, 2023 at 5:43 am
Michael, have you seen the movie Idiocracy? If not, just look around. AI is just another way for it to come true.
I hear about how good that movie was...
February 10, 2023 at 12:35 am
I guess you mean selecting them with union all, that's even worse performance wise.
It does.
No... and no where did I come close to even inferring that. I mean use...
February 10, 2023 at 12:31 am
I don't have access to SQL 2022, but I would think that a windowed function would perform much better than the CROSS APPLY.
Really good point on using a Windowing...
February 10, 2023 at 12:15 am
If all the databases are on the same instance, why do you need to use a temporary table?
Also, does your temporary table actually have the correct indexes on it?
February 9, 2023 at 9:02 pm
perfect, thanks
Yes, I'd defined VALUES incorrectly - typing rather than cut and paste
Just to be sure, are you all set now?
February 9, 2023 at 8:08 pm
And thanks for the reminder that I should probably publish the testing I did for that.
In truth, I need to do my own testing on it as well....
February 9, 2023 at 3:37 pm
Nope... not missing those points at all. Those are the points that I'm actually afraid of because the folks that need to use it are going to believe its "correct"...
February 9, 2023 at 3:25 pm
Viewing 15 posts - 1,921 through 1,935 (of 59,066 total)