The second will be better by skipping unneccessary data modifications / triggers. No point in updating billions of 999 rows to 999 rows where there are only 3 <> 999...

Answers without samples

#1: joinorder doesn't matter. SQL Optimizer permutates join order in order to get the lowest cost plan. You can switch the join order in your statement. Beware Left...

I haven't experienced major delays with Microsoft Authenticator sofar

Glad it sorted out!

C# . It's mostly used by our devs.  ( it helps translating ORM implementations ). Investing R / ML is on hold as you need quite a statistical background

I welcome the free toolset and hope it gets a place next to sp_WhoIsActive, FirstResponder.

Are there real world examples where the tool was used?

You may also try configure HTTP first and then switch to https

Not really.

Currently I have the following in PowerBI rsreportserver.config

<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>....../AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportServerWebApp</Name>
<VirtualDirectory>Reports</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>........</AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>

I would suggest setting max ram per instance.

As far I know SQL Server keeps consuming memory and never releases it, potentionally not leaving enough ram for OS, AV, ...

It can...

Thanks for voluntering. It's certainly helpful to make the skills more popular.

At Belgium we have coderdojo's to learn children to create websites, games, ... in the hope they will use...

You've must have exhausted all other options. Maybe they have a six figure salary job opening

Happy holidays and Merry Christmas! Have a healthy and fun 2022

Doing fine. Bracing for omikron impact. There is also some budget tightening, luckily most sql databases are now sql 2019 or azure

I disagree with Chandler on avoiding an ICT position but heartily agree with "No position is worth dying over". Live your life instead of being lived.

Remote work is way more...

How's everybody? Wishing a good 2022