Category Archives: SQL Tuning

RedGate SQL Index Manager BETA

I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL Index Manager.  This tool is aimed at the accidental DBA or for those like me who are just lazy.  🙂 … Continue reading

Share
Posted in SQL Tuning | 1 Comment

Shrinking Transaction Logs

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 … Continue reading

Share
Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 2 Comments

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning | 5 Comments