@david-2.gugg

Yeah that’s a really interesting point. You’re right — delayed durability is mainly a win for those rapid-fire, small commits where the log flush wait just kills throughput. With big...

Thank you so much for taking the time to read and share your thoughts

Really appreciate your kind words — they truly made my day!

It’s always encouraging to hear from someone...

@Jakub Janda.. Adding RCSI still cause below issues:

It doesn’t eliminate latching or I/O stalls.

It adds TempDB pressure (since row versions are stored there).

And it still doesn’t match the raw concurrency...

Hi Pascal,

Sorry for seeing your message late.. as I did not got any notification on email..

What is your system cpu? And which sql server version you are using..

This should be...

Hi @MMartin1

Thank you — that’s a great question!

You're right that BULK_LOGGED recovery model can enable minimal logging in certain scenarios. However, unfortunately, regular UPDATE statements do not benefit from minimal...

Hi Jeff,

Thanks for your comment..

This was 4 core I believe when I performed this testing.. As I recently upgraded it to 8 core for some further investigation

Thank you for your response, @Eirikur Eirikisson — truly honored to have you engage.

You are absolutely right: without comparing the execution plans side-by-side, especially for MAXDOP = 0 vs. 4,...

Thank you so much, @Brian Gale — I truly appreciate your thoughtful insights.

You’ve summarized the key takeaway better than I could. I completely agree: most of the time, query hints...

Hi again Anders,

Since you raised some great points, let me expand a bit technically here for everyone’s benefit — and ask a few questions that might help guide tuning.

You mentioned...

Hi Anders,

Thank you

My article was about covering multiple scenarios on maxdop.. I did not said to set maxdop to 1, But I told you should try to optimise your query...

Hi William,

Yes I accept a few inconsistency which I will get rectified. But the message and step is clear.

Below are

1. Probable inconsistency: Step 1 specified "we attach a new Azure-managed...

Hi MMartin1,

We need to seed the root node first.. This has come in screenshot but not in code.

INSERT INTO @Hierarchy (ID, ParentID, Name, Level)

SELECT ID, ParentID, Name, 1

FROM HierarchyBig

WHERE ParentID...

Thanks Rama

Solid catch with that CAST —Really sometimes it's the smallest tweak that makes all the difference.

Also it came as surprise  how just a VARCHAR(100) vs VARCHAR(50) can silently mess up...

Here’s how to fix the issue with SQL Server not finding the system databases:

1. Check if the D: drive still exists

• Open File Explorer and see if D: is there.

...