Unless you're actually storing the result in a database field is there any performance difference between varchar or char?  If you are just for example returning the result set...

Instead of quoting the column names - I would recommend changing the names to something else.  For example:

plan_name instead of [Plan]

total_count instead of [Count]

total_amount_dollars instead of [Amount ($)]

Makes it much...

I find it interesting that...

When I did the failover to secondary. I had database was recovering on former primary, but it was very slow taking longer. If that is the case then you...

Why do they need to see that information?  It could contain sensitive data (e.g. passwords) that should not be exposed - and really doesn't provide any additional information that is...

For a small set of data I might use a table variable - but for any significant number of rows I would use a regular temp table.

Another option - you...

There really isn't any method to recover that is going...

I am very curious as to why you want to build a manual process to monitor for errors.  There are many automated ways to notify when an error occurs and...

As part of adding the DB back into the AOAG, you will need to restore the "fixed" copy onto the secondary so you will overwrite that copy of the...

Better yet:

SELECT CONCAT_WS(';', col1, col2, col3, ...)

With that said - since this data needs to be uploaded to an FTP site, I would build...

You also need to consider who and how agent jobs get created and managed - it is possible but also needs planning up front to ensure that each team is...

Regardless of how indexes are selected to be rebuilt - space is required in the data file to rebuild the indexes.  If you are constantly shrinking the data file, rebuilding...

There is a function available - use that instead:

Use <database>;
Go

If sys.fn_hadr_is_primary_replica()) <> 1
Begin
    Raiserror('%s is not the primary replica - exiting...', -1, -1, @@servername)...

It depends on how the packages are deployed - if deployed to the catalog you can update the values in the deployed project or update the values in the agent...

It looks like you removed the original question - so I am not sure what that was, but this actually seems like a good candidate for using EXCEPT.  It seems...