Home Forums SQL Server 2008 T-SQL (SS2K8) Add unique valules to a heap RE: Add unique valules to a heap

  • September 15, 2016 at 11:37 pm

    #1901266

    durga.palepu (9/1/2016)

    Yes, its always a best practice to have a primary key on table to avoid the heap. It can be either simple identity column or any business key.

    Also as our experts suggested, its always suggested to have unique index on filtering column.

    Thanks,

    Durga Prasad.

    Ah... you said "always". Are you a betting man? 😀

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