Too bad it wasn't a windows update patch, but also good that your servers are all up to date patched.

As a thought - when did this problem start?  Could be...

How does this code look:

CREATE TABLE [#test1]
(
[IDColumn]  INT
, [MemberID]  INT
, [Startdate]  DATE
, [Enddate]  DATE
, [7DayRedamit]  BIT
, [30DayRedamit]  BIT
, [60DayRedamit]  BIT
,...

Looking at your execution plans, both of your FTI's are pretty quick.  0.028 seconds on one of them and 7.080 seconds on the other.  The slow part is your clustered...

If these are VM's, it could be how the VM host is handling the memory.  Balooning (in VMWare) I think can cause odd issues.

It is weird that nothing is showing...

Might help to see the execution plan...  Without that we are really just guessing.  Maybe SQL isn't using the full text index?  Maybe statistics are out of date so estimates...

Just to confirm with you - Power BI is sending 2 emails; it ISN'T that SSRS is sending one and Power BI is sending one, correct?

This should be easy to...

I personally haven't done this, but a quick google brought this up:

https://officeline.gr/2020/04/04/azure-failover-cluster-with-shared-disk-step-by-step/

It explains how to set up a failover cluster with shared disk in a step-by-step process.

To me, my first thought when I start getting timeout errors is that it is something in the network stack.

If you are connecting to a SQL ALIAS instead of the...

Glad it works!

Also, figured out why I needed it lowercase as I was confused on that too, it was just how it worked for me.  The URL in the XML...

My output looks different than yours for sure:

I ran the following:

DECLARE @xml XML = '<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <Description />
  <DataSet...

As a thought, when you ran dtutil.exe, is %f the FULL path to the file or the relative path?  May want to remove the "/quiet" option and just see what...

My preference is before partly because that is what was done before I started and partly because that is my habit from .NET development.

From a C# side, my opinion is...

We should be able to get that value... I don't get it... I changed the XML to be this:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/sqlserver/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition" >
 ...

Are you using X.VALUE or D.VALUE?  your X.VALUE ones will give you the first result found, the D.VALUE ones will give you one result per row.

Where I work, we do...

I think that really falls into an "it depends" category.

Based on your description, SSIS is likely going to be the best tool.  I would advise against a stored procedure only...