to add more details, in the current setup,

Primary Active Read Write,

Secondary Active Read- Only

On the primary, we apply product scripts like altering stored procedures, adding index, adding column, alter/create view...

Thanks for the response, I will test it with a small data set, but wanted to hear from Gurus who already did it and experienced issues,

question is if I use the GUI and do it, it will do that  automatically correct?

drop and creating index as needed? will partitioning a 80 M row table on the...

datetime used as partition column  is Non clustered ix.

the id column of the table is pkey , clustered index,

prevent duplicates, ignoring case would be better

Thanks for the response, what about Kafka and Azure Serverless / Hyperscale? just for POCs

I don't think they will rearchitect the application to move out from SQL Server as of...

Thank you Steve for reaching out to Microsoft, Two separate issues we have ,

the current OLTP DB with Transactions  is already at 5 TB , there are common tables used...

Thanks Steve , Its in preview and wont help as we need two stops . Primary 8 TB data cannot be taken down and its on Azure MI,

need some solution...

Another use case I need to provide solution

There is a high profile customer who will send 3x data and wants 0 downtime,source is azure mi business critical, what options can...

Thank you Steve for the response, The question is around database, can we have Active- Active, Looks like in SQL we do NOT have that option. say we need to...

Its managed SQL Server Business critical, with the latest version, and MS automated management of Log file.

The issue here is there is purge and archival of data creating lots of...

These are my file names and sizes.

Please send me scripts so I can shrink file in smaller increments ( from 3 TB to 2.9 TB to 2.8 TB etc and...

Thanks Fredco.

dbcc shrinkfile low priority, may be I need a script to reduce the size 100 GB at a time from 3.2 TB to 1 TB.

Secondly, Log file shows 260...

Thank you Brian for the detailed reply, here we want to track updates on three tables on Selective columns , may be Change Tracking is the best solution, and we...

I think to check multiple tables for selective column updates, to remove dependency.

Need to identify those and move those to another table