Tag Archives: indexes

Optimizing Database Performance, part 2: Denormalization and Clustering

In Part 1 of our series introducing database performance topics and considerations we tackled the issues of partitioning data and creating indexes. In Part 2, today, we will introduce the topic of denormalization and clustering. Denormalization Another way to optimize the … Continue reading

Posted in DBA | Tagged , , , , | 6 Comments

Bad Database Standards, Part 1

With this blog entry I start a new series discussing bad database standards. Almost every DBA group keeps a database standards manual – but most do not keep it up-to-date. I’ll try to tackle some of the more popular standards … Continue reading

Posted in DBA, standards | Tagged | 2 Comments