Post reply

How to decide to aggregate data in SQL Server or in Report Server

  • August 27, 2009 at 11:28 am

    #1045726

    There's really only one way to know for sure... try both with Profiler running. Select the one that uses the fewest resources for CPU and Reads. Both should be very fast, though. The deciding factor will be the number of resources used on the server, though.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing post 1 (of 2 total)

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