Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that I support contains 23 columns per table and 16 of those columns have a non clustered index. That’s it, that is all there is to the table? Each month a new table is created and […]
Category: SQL Tuning
If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are failing to do this simple task? It could be things as simple as having a monitor tracking successful backups, amount for free disk space on a drive or the amount of free space in your […]
If you truly want to understand something try and change it.
I saw this quote on facebook last week and it really hit close to home. I had just started working on a request at work to produce a flat file from a database I support that was to replace a similar file being produced by another team. The other team was having to create a […]
Inheriting a neglected DB
About a month ago I was in a position to take over support of a large database and handle the upgrade from SQL 2000 to SQL 2005. The database is approx 800 GB in size. Not the largest DB in the world, but the largest for the company I work for. Upon taking over the […]