September 17, 2013 at 9:26 pm
Comments posted to this topic are about the item Primary Keys which are not Clustered Indexes in a database
September 25, 2013 at 7:55 am
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
September 25, 2013 at 11:34 am
Many thanks for your feedback kurt
April 27, 2016 at 4:53 pm
Good ideas in your script, thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply