One way to make your DB2 database use less storage and speed up Inserts and Updates is to drop the indexes that are never used.  As the application changes and the database workload changes, you may find many indexes are no longer needed.  Dropping these will free up tablespace pages, not to mention speed up database backups and general database maintenance. Starting with DB2...
Read More About Drop the Dead Weight in your DB2 database. »

  As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA.  In fact, a recent survey reported that 45% of IT personnel responsible for managing their company’s SQL Server instances are not trained database administrators instead...
Read More About The Value of Expertise »

A colleague wanted to work an old Henny Youngman joke into a performance analysis. He wound up not using it, so I will: Man goes to the doctor. He swings his arm and says, "Doc, it hurts when I do this." Doc says, "Don't do that!" I came across this error message this morning:   Mar  6 2012  3:02AM|Error: 7886, Severity: 20, State: 2. ...
Read More About Don't do that! »