Expanding on Scott's idea - since you want a total of the values:

SELECT 
    [...],
    ca1.TotalStuff
FROM #OrigTable OT
INNER JOIN #BucketExclude BE...

If you need to dynamically create the SQL statement - here is one possibility:

1. Create a stored procedure on the source/destination system that generates the SQL as needed.  This should...

Look at what the resulting values are that come out of the hash match - in the first query the number of rows is less than what you see from...

• This reply was modified 6 years, 2 months ago by Jeffrey Williams.

Looking at the difference between plans:

The first plan utilizes an index scan using the index ix_TaxLok with no predicate.  This results in an estimated row count of 124720 and an...

Starting with SQL Server 2012 - we now have the Integration Services Catalog.  Deployment of SSIS should be converted to project deployment and deployed to the catalog.

I would also recommend...

Glad this helped...

What is the relationship between [SA Releases].Date and LoadTransaction?  Is there a date column in LoadTransaction?

Assuming you want all records for today from [SA Releases] and only those transactions from...

If you want a solution that can have any start/end date for any range - between 1753 and 9999:

Declare @startDate datetime = '1753-01-01'
    ...

• This reply was modified 6 years, 2 months ago by Jeffrey Williams. Reason: Removed an extra Top that wasn't needed

Here is an option...

Declare @startDate datetime = '2020-01-01'
      , @endDate datetime = '2021-01-01';

   With dates (y, StartDate, EndDate, Feb28)
 ...

It is actually much easier now than...

The only thing that comes to mind is database compression - or the original database had a lot of extra space in the data file and the cloud team performed...

Try this link: https://www.microsoft.com/en-us/download/details.aspx?id=56836 for SP2 and this link: https://support.microsoft.com/en-us/help/4527378/cumulative-update-11-for-sql-server-2016-sp2 for CU11.

You should be able to restore to the same version - the error you are getting indicates that the...

Normal schema changes won't be an issue for the AG - they will propagate to the secondary database very quickly.  With that said - if you are adding new columns...

I did not use a parameter - I defined a variable instead...

One more note - if your goal is strictly HA then your virtual environment can provide that for you.  You should be able to move the VM across hosts as...