"I'd like to create a column that will list every Monday (start of week) from the enrollment start date to the end date. If no end date, then it will...

I had a scary experience with CPU on a database server reaching 100% due to bad plans from badly written code. I have had all members of my team looking...

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