Viewing 15 posts - 91 through 105 (of 6,037 total)
Never did understand ads that have nothing to do with reality.
How many ads did you actually see?
How many of them passed reality check?
Any?
_____________
Code for TallyGenerator
June 30, 2021 at 2:27 pm
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
Viewing 15 posts - 91 through 105 (of 6,037 total)