Creating new db wont work, as there are 100's of tables, and millions of rows and its a live DB being used.

I would say its a microsoft defect expecting us...

Thank you! This is the only solution and best I think !

can it be done in batches, say every weekend for a month?

datafile= 3 TB

logfile =200 MB

But size of all Tables =500 GB, what is taking 3 TB space, I need to free up the storage , to save $$$ ( storage...

Will the app continue to work ,

When we are swapping Data, partitions etc from un partitioned tables to partitioned tables, 24x 7 shop with only 1 hr downtime once a...

Two questions:

On Azure MI, we cannot create  FGs and add multiple files, I think.

This is Prod there are 4 largetables which they want partitioned , can partitioning be done on...

only way I can do is select min(logid), createdate from tablename

once I get logid , I use it, for delete . as i said Only logid is indexed ( pley...

Datecreated is this format, may be need to create a new computed column from this ?

2023-07-31 02:00:15.470

Thanks for the quick responses on Friday

Yes pkey clustered on logid

Time stamp is datetime , not null , Ok to index on timestamp?

Thanks for the quick response

3409177 rows, ofcourse only way we query is using logid ,

Is it normal to create IX on timestamp, never heard of that ?

since error is varchar(max)...

Thanks for the message,

What are the disadvantages of partitioning? does it need manual management?

Can we fix those issues which partitioning addresses using other solutions?

Update to CU8 , to fix it..

its not that easy, we have 1000 IIS folders on the web and the web.config points to serverA, so I need to know if there is a way to shutdown...

yes one DB per customer, I would say 500 of them on one instance are active ( sizes are relatively small)- largest 100 GB, smallest even 1 GB..

we have a  lot of sproc code which was running slowly across 1000's of DB's in production. I understand this is normal , but hoping to get a magic recompile...

countrycode- table ca_dataDictionary_Countries

site_id- table ca_site_Study