The whole idea behind the script I posted is that it will return the same information as Activity Monitor.  In fact - it is the exact same query that is...

The issue with Activity Monitor is not actually related to the version of SSMS - it is an issue with the version of SQL Server.  This issue only shows up...

Review this item: https://feedback.azure.com/forums/908035-sql-server/suggestions/37050118-ssms-17-9-1-activity-monitor-pauses-when-open-proc

If that is the issue - you can use this script to get the same data as you would from the processes tab:

 ...

Copying a table from one database to another database on the same server will not have any impact on performance unless that other copy has different indexes or there are...

I never use automatic seeding - even on databases that are small enough.  The process I use - and one that has not failed yet...is:

1. Backup database on primary
2. Backup...

This was a request that came in as an attempt to eliminate cross database queries made by the stored procedure that gathers data from 11 different tables across 3...

If it is an issue of trailing control characters - you could also use SUBSTRING or LEFT to truncate the string and convert:

SELECT cast(substring('16.3%'+CHAR(10), 1, charindex('%', '16.3%'+CHAR(10),...

I have to ask - why do you need a second copy of the table in another database on the same instance?  Just reference the table from the production DB...

If you are looking to filter this based on whether or not the parameter @PatientID and/or @CareProviderID is passed in - then include that in the WHERE clause instead of...

Can you clarify:

Is the backup file the same size as the backup file you sent to the cloud?  Or - is the restored database the same size as the on-premise...

Is there a reason you prefer subtracting the excluded amounts - instead of  just adding up the amounts for your own total?  Is it possible that the TotalStuff column has...

looking at your execution plan, 9 million rows at 15 bytes per row is not very large, so it was able to read the entire table and do the...

Here is an idea:

Declare @yearID int = 2019
      , @periodIDValue varchar(3) = 'P12';

 Select dateadd(day, -1, dateadd(month, 1, cast(@yearID * 10000 +...

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