Viewing 15 posts - 91 through 105 (of 6,036 total)
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...
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...
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...
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)...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
May 29, 2021 at 5:16 am
Temp tables won;t change much in terms of overall performance. May be make it a bit worse.
I'd suggest following changes to the query:
SELECT p.acct, p.processdate,
m.product + m.productcode...
May 29, 2021 at 5:05 am
Viewing 15 posts - 91 through 105 (of 6,036 total)