Monthly Archives: July 2012

Database Performance and Row Size

I was reading through some posts in a database-related newsgroup or mailing list (actually, right now I can’t remember which one it was). The conversation I was reading was in response to a question like “Does the number of columns … Continue reading

Posted in database design, performance | 3 Comments

Diminishing Downtime

One of the on-going goals of database administration is to minimize downtime and improve availability. If the DBMS is down, data cannot be accessed. If the data is not available, applications cannot run. And if your applications cannot run, your … Continue reading

Posted in availability, change management, data integrity, DBA | 2 Comments