It sounds as if you need multiple stored procedures.  Call the appropriate one depending upon the ID.

Thanks.

We are planning for Failover cluster.

Regarding point 3.

You mean SQL updates(ex  edition, upgrade, patches etc) and OS updates will have to be done on both nodes separately

and within sql...

Sure. Go for it.

Here are some more guesses.  More Ram. ...

Please assist. I installed KingswaySoft.IntegrationToolkit into my SSIS software. I am trying to move data from SQLServer to Google Bigquery. I am getting this error:

[Google BigQuery Destination [2]] Error:...

You have an availability group, and the secondary replica is read-only.  Statistics cannot be updated on a secondary replica.

And your symptoms do not...

My apologies, but I "mostly" understand.

To a team that only knows the name "DB1" to which to push the data, we would do the following:

1).  Create two databases.  DB2,...

Thanks. Changing the setting is relatively easy and does not require a server restart to take effect. I agree like will cause data or procs to leave their caches...

You're guessing and hoping for a magic bullet.

How many...

You are seeing these waits for the individual query? Or is this for the instance?

What reason are you using a float?

One possibility is the use of SYNONYMs to help you in this.

Assume that the synonyms 'point' to tables in DB1 on day 1.

On day 2, DB2 is updated....

As to putting FKs on an audit table... don't EVER do that.  There's not reason to because the rows have already survived the INSERTs and UPDATEs for...

As to putting FKs on an audit table... don't EVER do that.  There's not reason to because the rows have already survived the INSERTs and UPDATEs for FKs and...

The DaysUntilExpiration argument will return NULL if the setting enforce password policy or expiration are not checked.

You may want to add a check to see if these are checked, and...

If step 4 fails, in the setting of the step, can you simply set it to go to step 1?

Of course, you run the risk of going in an endless...