Can you share some more details, don't like guesswork?

😎

Quick question, is the application's query interface a predefined API or dynamically constructed SQL?

😎

Capturing the queries on the server comes with a considerable overhead, I suggest you do an impact...

What is the problem you are trying to solve?

😎

First of all, establish what the issues are and then target those issues! Without a proper RCA (Root Cause Analysis), I will not provide any guesswork on a possible solution.

😎

Another...

Piling on Jeff's solid advice, the term "throttle" can have different meanings! My perception is that the requirements are not clear enough!

😎

Far too often, throttling is thought of as a...

Quick Question, do you have clear RPO and RTO?

😎

Without those, designing a DR solution will be a futile exercise!

Johan has a good point, just as Orwell stated, not all "versions"...

First thought, check if security and permissions for the Agents Service account are identical on all instances.

😎

A solid advice from Lovell as usual!

😎

I have used the backup method many times with only a few minutes of downtime, even on relatively slow connections. Suggest that you script...

Quick question, what are the recovery mode and backup details?

😎

Recursion is notoriously slow for iteration.  Maybe use a "standard" tally table instead:

;WITH
cte_tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally100 AS (
...

Here is a very efficient way of doing this.

😎

Comments in the code.

USE TEEST;
-----------------------------------------------------------------------------------------
-- WHEN POSTING CODE ONLINE, I MAKE CERTAIN THAT IT POINTS TO A NON-EXISTING DATABASE...

A quick question, is this the format of the data you must work with or can you correct the data structure? Adding columns for each month is not a sustainable...

Nice one Steve!

😎

I like short questions, with short answers and even shorter query outcome 😉

Just adding my 2cents;

1. Are the views' queries fully covered? (look into covering indices)
2. Can the cardinality from each view be limited up-front? (look into inline table value functions)
3. Are...