Post reply

How can we compress the tables in a database

  • November 30, 2011 at 1:46 pm

    #247006

    Hi,

    How can we compress specific tables in a database. Please helpme out

    In advance thank you 🙂

  • November 30, 2011 at 1:59 pm

    #1414935

    yes, but only with 2008 and above, and i'm not sure if this is an enterprise edition only option. partitioning is certainly Enterrise only, but i think compression is part of standard editions.

    take a look at books online here:

    http://msdn.microsoft.com/en-us/library/cc280449.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 30, 2011 at 2:11 pm

    #1414942

    AAKR (11/30/2011)

    Hi,

    How can we compress specific tables in a database. Please helpme out

    In advance thank you 🙂

    http://lmgtfy.com/?q=compress+specific+tables+msdn

    Alex Suprun

  • November 30, 2011 at 6:24 pm

    #1415002

    Lowell (11/30/2011)

    yes, but only with 2008 and above, and i'm not sure if this is an enterprise edition only option. partitioning is certainly Enterrise only, but i think compression is part of standard editions.

    take a look at books online here:

    http://msdn.microsoft.com/en-us/library/cc280449.aspx

    Compression is available only in the SQL Server 2008 Enterprise and Developer editions (from that link).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply