Secondary Replica 2 (same location Sync mode for fail over) There should be no blocking, unless you have some really bad queries as the secondaries are read-only.  Why...

On the disk usage report - where is it showing the space being used?  If the tables have LOB data - the space could be allocated for the LOB's but...

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