I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE UNIQUE NONCLUSTERED...

One of the tables you're joining to must have an extra matching row in it compared to what you were used to seeing.  I can't tell which one from what...

Would you give us actual table data -- i.e. CREATE TABLE and INSERT statement with VALUES -- rather than just a picture?  We can't write SQL against a picture :-).

This...

Hmm, interesting.  Lots of indexes there, so we'll need to do a full analysis, if you're willing.  Please run the attached query and post the results in some type of...

Adding a running number can add records if before the column addition there were duplications that were shown only once but after the column addition they stopped being duplications. ...

I can't offer index recommendations without seeing the DDL for the tables, including all current index definitions.  The most critical index is the clustered index, so that should be determined...

I typically use SSIS to do that, since it has the inherent capability to run multiple imports async.

We need to see DDL for the tables, including index definitions, the query plan and the query itself.  There's no way for us to just imagine what is happening and...

Are you really only returning a single column from the query?

If so, change to SELECT just from the table with that column, and use a WHERE EXISTS() on the other...

Exactly.  And that's what I meant too.

Jeff said that he'd "still" "say NO".  But, once you've made your objections known, and in writing for the record, and management still decides...

Maybe?:

,(sum(isnull(sc.numberofprocedures, 1))) 'ProcCount'

Your own login must not have SHOWPLAN permissions.  Check to see if someone will GRANT you that permission.

As a DBA, I give that permission to everyone.  I don't see how...

Hmm, ran fine for me, but I'm on SQL 2016.  I think that code should work all way back to 2008, or at least 2012.

We could join to the entire...

;WITH cte_test_data AS(
    SELECT * FROM ( VALUES
        (1,'Not Paid', CAST('7-1-21' AS date)),
    ...

Hi,

I'm in the process of doing a comparison of all the options available:

Scripts Integration Services 3rd Party Tools

We will have hundreds of instances and thousands of databases so need...