Test out the solution I provided with data that varies in the first few columns and adjust the pivot experssion as needed.

For dynamic SQL, try the following >

declare @sqlStart nvarchar(200)=
'Select *
FROM    (Select custID, staffId, jobID, dt, sum(units) as units      ...

One of my favorites was a project I did earlier in my career. What made it special was that I was learning as I went along and was given the...

Indeed from Microsoft Docs ---

"> 0 = FILLFACTOR percentage used when the index was created or rebuilt."

The key term to notice is 'rebuilt.' So...

Thank you for the article. This is nicely explained. However I have a couple of questions.

The basic template is

CREATE [OR REPLACE] FUNCTION function_name (arguments) 
RETURNS return_datatype AS...

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...