Looking at the execution plan, the slow operation is pulling the 5 million rows from the Contacts table into memory.  It is taking over 40 seconds to pull the 5...

I may be mistaken but I am pretty sure what you are asking for does not exist.

If it did exist, I can't imagine the performance hit that would cause in...

My opinion (I work at a company that is SOX compliant), if you do your best to follow SOX compliance as best as you understand it and you pass the...

A few thoughts here.  First, update statistics if auto update statistics is not on.  And it may even help if that is on.

Second thought - I think you forgot to...

I think the result I posted in my second edit should work with the potential for a gap.  I think the only thing that you may want to add would...

I realized the mistake.  Actually multiple mistakes on my part.

First mistake I did was assumed that I could just add up the number in the xxxDayReadmit column, but you want...

• This reply was modified 5 years, 4 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 4 months ago by Mr. Brian Gale.

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