I agree with curious, believe your confusion is justified.  If they intend to use same address in different subnet, then what is their definition of "different subnet?"  Seems to me like...

We don't let devs modify production code or processes.  There is a line between development and implementation.  Having said that we've hacked msdb a bit to allow some our devs...

>> Does setting RegisterAllProvidersIP to 0 similar to MultiSubnetFailover=True <<
I think it's the opposite.  If your clients don't default to MultiSubnetFailover=True, and you cannot change connection strings, then I think...

Well done.  CTE vs derived table is purely aesthetic choice I think.  One typo/mistake: "select DATEADD(yy, GETDATE(), - 1)" has 2nd and 3rd params reversed.

With 2012 we initially used sync AGs for HA, and async AGs across our WAN for DR.  We experienced many HA failovers that should not have occurred...in fact most of...

I think best way to do this is with partitioning ALTER TABLE ... SWITCH command.  It is instant, can be done within a tran if you like.  See Dan Guzman's 

User error, attach failed, trying again

Thanks for the feedback.

Fernando Jacinto Alvarez: I don't know, recommend you test this

aswini.gangaraju: yeah, I should have done this before, just so tedious. Not sure...

Nice editorial today.  Thank you.

You can disable logins to prevent further activity while still keeping things online while you wait for system to quiesce.

Nice.  I was surprised by your finding, just ran a small test and confirmed the storage consumption.  Did not expect this.  Now I plan to run some more tests and...

I think this is easy to test for yourself. On dev instance create very small DB, and in it a test table that meets your criteria. Fill the...

FWIW, I've administered/created many tables like this, never saw any terrible pain point.  Some wasted space maybe.  But I am trying to do better, and am pretty sure this is non-optimal. ...

Sample 2

Good read!  Thank you.