Home Forums SQL Server 2008 SQL Server 2008 - General Odd table sizes RE: Odd table sizes

  • January 7, 2013 at 2:54 pm

    #1574540

    Mick Opalak (1/7/2013)

    I verified the row counts using COUNT(*) and they match, as I would expect. However, the publisher has a much larger data size.

    Is there a clustered index or is this a heap? Heaps do have an issue of not releasing space from delete records http://support.microsoft.com/kb/913399. Its a known "Issue" with heaps and why i tend to use a clustered index on every table.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]