denormalize

  • Is it ever appropriate to denormalize?

  • yes

    .

    .

    .

    New homework assignment ?

  • yes,thank you

  • When do you think it might be appropriate to denormalize?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • When performance is more important than the overhead incurred by the extra work of maintaining information in multiple areas.

    --------------------------------------------------------------------------
    When you realize you've dug yourself into a hole....Step 1...stop digging.

  • Charles.Otten (12/8/2010)


    When performance is more important than the overhead incurred by the extra work of maintaining information in multiple areas.

    He wasn't asking you 😉

  • I was unaware it was a private discussion.

    <-- Unsubscribed

    --------------------------------------------------------------------------
    When you realize you've dug yourself into a hole....Step 1...stop digging.

  • Charles.Otten (12/8/2010)


    I was unaware it was a private discussion.

    <-- Unsubscribed

    Not private. Sorry for the confusion. But some people need encouragement to put in some effort finding answers rather than just ask open ended questions and expect others to do the work for them. I ask plenty of questions myself, but there are many people here with vast knowledge who never need help, give their time for others, yet get treated as if they are paid support. (Did I rant too much ?)

  • My vote for homebrew01. Very well said!

Viewing 9 posts - 1 through 8 (of 8 total)

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