Viewing 15 posts - 91 through 105 (of 6,036 total)
The bottom line is as it always is... "It Depend" on what is needed. 😀
Yep, too right.
It depends, and it depends on requirements, not on file size or any...
_____________
Code for TallyGenerator
June 30, 2021 at 2:21 pm
Do you have an actual example of a 30 million row transaction where every row was actually required or you had to fail all 30 million rows? I'm not...
_____________
Code for TallyGenerator
June 29, 2021 at 2:16 am
Anyone know a full stack developer looking for a job at a good company? We're looking for several and haven't got great candidates (some good but with little to...
_____________
Code for TallyGenerator
June 27, 2021 at 2:59 am
That might also be the reason why they've done the RBAR thing in the trigger. They don't want to have everything during and Insert or Update roll...
_____________
Code for TallyGenerator
June 27, 2021 at 2:38 am
Came across an actual query which gave me an idea about another version of the test script for DISTINCT vs. GROUP BY.
create table #BalanceType (
id int identity(1,1)...
_____________
Code for TallyGenerator
June 8, 2021 at 5:50 am
To me, this is the area that DevOps, GitOps, anything Ops, automated, or at scale, needs to mature.
Dont forget to add Agile to the list.
For those to mature means to...
_____________
Code for TallyGenerator
June 8, 2021 at 2:33 am
Copying of columnstore by row-based batches makes very little sense, if any.
It's Columnstore, so it has to be copied in the way which matches its definition - by column.
No matter...
_____________
Code for TallyGenerator
June 6, 2021 at 1:17 am
In University, you pick up humanitarian subjects, if you're bad at Math.
Pretty much the same situation with NoSQL/SQL.
_____________
Code for TallyGenerator
June 5, 2021 at 10:28 am
That's what I've seen in normal usage, too
In my years working on SQL Server I extremely rarely saw a database where I could not improve performance for at least...
_____________
Code for TallyGenerator
June 5, 2021 at 2:26 am
There is no difference in the execution time in this case.
In this case - yes.
Because GROUP BY is applied to the output of the SELECT - making it equal...
_____________
Code for TallyGenerator
June 3, 2021 at 12:14 pm
Well that didn't demonstrate any performance improvement from using group by.
It explained where the performance improvement comes from.
If you want to see it - just rewrite any...
_____________
Code for TallyGenerator
June 3, 2021 at 4:07 am
Well that didn't demonstrate any performance improvement from using group by.
It explained where the performance improvement comes from.
If you want to see it - just rewrite any of your...
_____________
Code for TallyGenerator
May 30, 2021 at 6:46 pm
The important points are these:
- DISTINCT is pretty nasty beast. There is no excuse for lazy programming using it, even if "everyone does it".
I don't see why/how...
_____________
Code for TallyGenerator
May 30, 2021 at 6:32 am
A teenager who was crazy about sound and recordings, who payed with mixing and recording on hid DIY home equipment, met a professional sound engineer, which brought the youngster to...
_____________
Code for TallyGenerator
May 29, 2021 at 10:54 am
Can you share a link of how to do that? It is a banks Database, do you think they’ll let that happen?
What kind of link you're asking for?
CREATE INDEX...
_____________
Code for TallyGenerator
May 29, 2021 at 5:16 am
Viewing 15 posts - 91 through 105 (of 6,036 total)