Home Forums SQL Server 2008 SQL Server 2008 Administration How to Reduce the Table Size... RE: How to Reduce the Table Size...

  • July 30, 2014 at 5:19 am

    #1733521

    Koen Verbeeck (7/30/2014)

    Chowdary's (7/30/2014)

    Dear Eirikur Eiriksson,

    How can i claim my space from that table without doing Compress, Can you pls give me some suggestions..

    Regards

    Chowdary....

    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.

    Quick questions

    1. What is the output of this query?SELECT SERVERPROPERTY('Edition'),SELECT SERVERPROPERTY('EngineEdition')

    2. Can you post the CREATE TABLE script for the table?

    3. Is this a production server?

    😎