Scott - Thanks for the reply. So when you stop the Agent, what happens to the jobs that were supposed to run during the stoppage? That's mainly what I'm...

I find it interesting that we had a fully scalable database platform - and it was killed by HP when they discontinued development on the OS.  VMS had the capability...

I would start here - this article explains how to setup a policy to monitor for RTO/RPO and alert if exceeded.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups?view=sql-server-ver15

This article shows how to capture data using Extended Events:

https://techcommunity.microsoft.com/t5/sql-server-support/troubleshooting-redo-queue-build-up-data-latency-issues-on/ba-p/318488

I...

To process IIS logs - the first thing you must do is change how those log files are configured.  In IIS - you need to at least add the server...

There are 2 processes you need to check - the send queue and the redo queue.  The redo queue on the secondary has to apply all of the transactions to...

drag a data flow onto the control flow panel - double-click the data flow which will transition you to the data flow tab. Once there - from the SSIS toolbox...

I see, I think an inner join would do the same job.

I can't see how your stored procedure is reusing a temporary table from another call. It...

I see, I think an inner join would do the same job.

I can't see how your stored procedure is reusing a temporary table from another call. It looks like...

If you are looking to pull a number of columns in a single row - you can use the 'Execute SQL Task' - set the ResultSet to 'Single Row' and...

Shifting gears a bit but on a similar subject... the PIVOT operator in MS Access is totally awesome.  I do NOT understand why MS made such a crippled version...

IIF(column1 = 'A', 1, 2) = CASE WHEN column1 = 'A' THEN 1 ELSE 2 END
NULLIF(column1, '') = CASE WHEN column1 = '' THEN NULL ELSE column1...

This really isn't clear - how is the offset being used?  It doesn't seem to be considered in the calculation - it seems that you want to get the previous...

And yet - ISNULL, COALESCE, NULLIF are all converted to a CASE expression (not statement) under the covers so they all should not be included by your argument.

Your argument against...

How are you going to present a row with 365/366 columns...

Sorry, hit enter. It would be good to understand if you want 1 or 2 fields in the result. The way you write this, I'm not sure. I think...