Home Forums Article Discussions Article Discussions by Author Discuss content posted by Timothy A Wiseman An Informal Look at Database Performance RE: An Informal Look at Database Performance

  • September 8, 2010 at 6:32 am

    #1217883

    mortenmaate (9/8/2010)

    Thanks a lot for the great overview !

    One thing I would like to mention additionally: Look a the SQL Server version. In my experience many companies upgrade their SQL Server too rarely, and especially in the MS family of SQL Servers, great improvements in the product during the last 10 years can be an easy gain (like factor 10 improvements or even more in some scenarios). So get rid of that SQL Server 2000 bastard now! (Believe me: They are still out there).

    Heh... I love the older versions of SQL. That's were I learned all the tricks I know to make stuff work. 😛

    --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)