We are in the beginning stages of architecting this for our organization.  It's not going to be an easy project.  Some of the folks on the team think that we...

This article may help

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability?view=sql-server-ver15

Honestly, I would create three procedures.  One to take the flag and test for its value.  That in turn would call one of two other procs.  The reason is that...

You would be far better off starting a new...

This may get you some of what you want.

SELECT 
SS.name SchemaName, 
ST.name TableName, 
ISNULL(SI.name, '') IndexName, 
SI.type_desc IndexType, 
IUS.user_updates, 
IUS.user_seeks, 
IUS.user_scans, 
IUS.user_lookups, 
SSI.rowcnt, 
SSI.rowmodctr, 
IUS.last_user_seek, 
IUS.last_user_scan, 
IUS.last_user_lookup,...

If you never query the tables by the ID column you are adding to use in the clustered index, how does it help queries?

If I have a heap table...

Ok, that's normal.  It's what you want.  You have a 17 GB...

As a reference, I have a server with 30 databases whose total size is just over 500 GB.  The backups run to a UNC, and it takes approximately 40 minutes....

Looking at the backup size, it did not change much just about half the size of what it was before... as we do compress our backups it went from...

So somewhat shy of 3GB?

😎

Something is not right here, my tablet regularly processes two times...

SharePain.  I have to remember that.

Not exactly.

It appears that there is an issue in the code that is attempting to do the insert.  "dbo" is a schema, and for some reason the code is attempting...

Sometimes you have to wonder.

I put together an extract of data for one of our clients for monthly invoicing. It's one of those clients that need to have all kinds...

Try this link.

https://www.sqlservercentral.com/articles/download-sql-patch-info

How about here:

https://www.sqlservercentral.com/stairways/stairway-to-alwayson