It can't be turned on with the secondary in 2019 or less (2022 only). When the primary fails over, it will have Query Store and the last good...

It can't be turned on with the secondary in 2019 or less (2022 only). When the primary fails over, it will have Query Store and the last good plan...

Thank you both for the good feedback.

Yes I see on the secondary there are no records when I select from

sys.dm_db_tuning_recommendations.

I dont even know the state on the 2ndary as nothing...

One item you may consider is partitioning especially if  one or a few of your tables make up a large majority of the size of your database.

Here is a nice...

One item that comes to mind is since these are different instances, the load on them can be different and there could be blocks/locks /activity on one that you wont...

The idea that you can accurately predict an event without seeing all the moving pieces implies there is an unknow. If you do this repeatedly then all you can predict...

" In all the cases I quote, the foolish detractors actually said loudly that something couldn't be done or wasn't so, which is why I believe we can and should give...

The article doesn't touch on the opposite effects.  While I certainly support and encourage research, experimentation, etc, etc, ad infinitum, you can't just go and do things because they're...

On the idea of using RDP to connect to a production system, I can offer an idea. Typically organizations have three environments. Qa, Integration, and Prod. For each of these...

I am a little risk averse when it comes to touching maxDop. After all, this query was running fine it was reported until this one time.

It is important to determine...

Yes a clustered index on the datetime column would help. Currently you have heap (no clustered index) so deleting records will not actually make the size of the table smaller...

OP must not be struggling that badly after all.

The regular expression here '%[^0]%' starts by looking for the first non zero in the string (col+'.')

120. --> 120

0150. --> 150

The ^ is a negation operator (meaning NOT) when inside...

Thank you Scott. I now know the naming of this type of scheme. I've seen it where the pk object has different properties based on the value in another column...