Be real, real cautious about using ChatGPT for any tuning advice. I was testing it out asking questions and it gets a lot of stuff badly wrong. I mean, very...

Here's all the recordings from the 2021 virtual event. That'll give you some idea. Otherwise, I'd suggest using the Wayback Machine and seeing if that shows last year's...

Several different things reset that information. It's part of why when someone says they're looking to remove unused indexes, I suggest caution when referencing that stuff as a way of...

This sounds like homework. Is this homework? In which case, I'll help where you have problems with the work you've done. Please note the tricky phrase, the work you've done....

I'll likely never make the attempt on these forums because it's not permanent to this forum.  If it goes away, any...

I did attempt to import your bacpac, but I don't think it's configured correctly:

Could not load file or assembly 'System.Resources.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located...

You need to backup the certificate. Microsoft lays it out right here. 

Remember, it's not just pages on disk. It's also pages in memory, and every page on disk has to be moved into memory.

Different question. Why does it matter? I mean...

And for Query Store, you may want to look at the settings for data collection. Prior to 2019, the default was to capture all executions. I'd suggest switching that to...

In addition to everything else already explained, you can go to the memory on the system in question and retrieve the execution plan from the Dynamic Management Views. This blog...

I do not have a good answer for you. However, I've reached out to see if I can find one.

Reads are not a measure of rows. They're a measure of pages. That includes disk and memory. For a tiny table, it's probably on mixed extents, so while, in theory,...

By its very nature, some of the interleaved execution that we're getting with all the intelligent query processing is going to cause some queries to slow down as the execution...

This is a big stored procedure which has multiple operations SELECTs, INSERTs within it and bunch of tempdb operations? The temp table error was something related to another operation...

First I am still learning this forum so do not know how to properly quote messages but to answer Jeff Moden 2nd statement then 1st.

I concur with your Steps...