I do the same thing with transaction log backups... if the "log_reuse_wait_desc" in the sys.databases view contains "NOTHING" for a database, then nothing in the database has changed...

Well - you should not be using '*' in your queries, as you noted you cannot do that and dump everything into a temp table.  You wouldn't want to do...

CMS is just a registry of instances...and is hosted on a specific SQL Server instance.  You can schedule agent jobs to run on that specific instance - but you still...

How are you connecting to the 'primary' instance?

Since these are reference tables (e.g. lookup, dictionary) - I would standardize the column names.  No need to put the reference type as part of the column name.  This would...

Are you thinking of Levenshtein Distance?  Here is a definition: https://en.wikipedia.org/wiki/Levenshtein_distance#:~:text=Informally%2C%20the%20Levenshtein%20distance%20between,considered%20this%20distance%20in%201965.

This can be done in pure SQL - but it would probably be easier to implement in Python or as...

You seem to be focused on the join between the CTE and the Inventory table - which is not where the problem exists.  The problem exists in the CTE portion...

You deleted,/truncated a large amount of data, your database physical size does not autoshrink. Many suggest pre growing your data files. If you are certain that your database will...

A multi-statement table valued function can be setup with a primary key constraint - in fact, you can define default values, computed columns, column constraints and index options in the...

The SSIS packages will not be automatically upgraded to 2019 - you need to open them in VS 2019 and upgrade them, changing the target to be 2019 also.  Deploying...

Unfortunately, a weekend is not always a Saturday and Sunday. You can have three and four day weekends, depending on how holidays fall. I've always found it better to...

I was thinking more about this - realized we can do this:

SELECT weekend_day_count=y/7-x/7+(y+1)/7-(x-1)/7

FROM (VALUES(DATEDIFF(DAY,-53690,'1899-01-01') + 1,DATEDIFF(DAY,-53690,'1900-01-14') + 1))x(x,y)

We can specify the anchor date as 1753-01-01 (-53690) and then...

No idea...messages are not coming from me, but from the topics you have subscribed.  Some of the messages have many, many, many posts and if you are subscribed to one...

If you are migrating to a new system - that is not part of a cluster.

1. Restore full backup to new server - with no recovery, on day of migration

...

Or a simple backup/restore process - you can backup the current database and restore as a 'master' database and set the new database as read-only (to prevent any changes to...