Primary Keys which are not Clustered Indexes in a database

  • Bodhisatya

    SSC Veteran

    Points: 263

    Comments posted to this topic are about the item Primary Keys which are not Clustered Indexes in a database

  • Kurt W. Zimmerman

    SSCrazy Eights

    Points: 8674

    Interesting script. I ran it against one of my legacy databases to which I manage but did not design. It was quite clear the designer didn't understand the principals behind good database design and the concept of clustered primary key indexes. None the less the database that supports the application which in turns houses a very large volume of high profile data manages to do its thing regardless of how inefficient the back end is designed.

    I have put almost 4 months in clean up, to a degree, making things a bit more tidy. Although I don't see as much stress on the database server and for me, I know things are much more quiet, at the end of the day the application marches forward and the end users really know no different.

    Bad practices are hard to break. I have spent many hours coaching better design. For the most part it pays off. If I can keep resource intensive process down to a minimum I guess I've done my job.

    Again thanks for posting this script. I found it quite useful.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • Bodhisatya

    SSC Veteran

    Points: 263

    Many thanks for your feedback kurt

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Good ideas in your script, thank you.

Viewing 4 posts - 1 through 4 (of 4 total)

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