we migrated from on prem SQL to Azure SQL. The size of the non-cluster index in onprem was 32GB but when I rebuild the index on Azure the size of non cluster index went up to 164GB. Shoud I first compress the table followed by index compression or I just compress the index any suggestions ? Thanks
Awesome! The animations used to explain are cool and helps in better understanding. Again Thank you!
Thank you
Pls continue with more videos keep it up
we migrated from on prem SQL to Azure SQL. The size of the non-cluster index in onprem was 32GB but when I rebuild the index on Azure the size of non cluster index went up to 164GB. Shoud I first compress the table followed by index compression or I just compress the index any suggestions ? Thanks
Alter the table and rebuild with page compression
@@Praasy Thanks , can you please share the script which can do it for the user defined tables at one go.. compress table + compress index