Koen Verbeeck (7/30/2014)
Why is compression not an option? Because of SQL Server edition?
Another way to reduce size - aside from the obvious: deleting data - is to choose your column data types wisely.
Every byte saved counts.
Hi Koen Thank you for response,
Am not sure abt that Compression that's y am getting tens..
If i do compress the table ,whether that free space can added to the database file or not.If no there is no use of doing that as per y requirement ,If yes we are happy with that.because there is less available space.