Monthly Archives: July 2012

Database Performance and Row Size

Posted on July 20, 2012 by craig@craigsmullins.com

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

Posted on July 16, 2012 by craig@craigsmullins.com

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