Tag Archives: database maintenance

SQL Server database file size

Keeping track of database size and growth is a critical part of a DBA’s job which I wrote about in an earlier blog post. But now I have improved my scripts that reveal the status of all my db files … Continue reading

Posted in Miscellany | Tagged , , , , , | Leave a comment

Identifying High Row count tables in SQL Server – New and Improved

A big part of good database maintenance is having a fair idea of where your tables are at in terms of numbers of rows and primary keys. I took a stab at writing a generic script to return all the … Continue reading

Posted in Miscellany | Tagged , , , , | 1 Comment