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

Are you saying you cannot get a static IP address assigned to a server?  It doesn't matter whether or not the server is virtual or physical - you should be...

What is the reasoning behind adding additional tempdb files?  Is there an issue you are trying to resolve - and have identified that issue as being related to tempdb?

If the...