I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space due to a very large transaction log. Post vary a bit on what the admin has tried but a common theme is that they have tried shrinking the file but it didn’t shrink and a […]
Category: SQL Tuning
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course doing all this testing and learning on a development system and thank goodness I am. I have found all kind of little nuances with getting this setup. A fun error I came across today after […]
Adding an Index to Save Space
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 […]
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 […]