• 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.

    Regards

    Chowdary....

    Regards
    Chowdary...