On my production SQL Server Enterprise Edition database 2014, I am trying to find why data files (.mdf) growing day by day.
I get the following report From Management Studio: right click on the database> reports > standard reports > disk usage by top tables.
I found some tables contain more than 70 million rows. One table takes more than 13625168 KB - almost 12 GB! What should I do?
Is there away to optimize the size of table even if contains a huge number of rows?
Some data is needed, other data only needed for archiving purposes.
Can I Compress the huge table?