SQL Scripts: How To Find Data And Log File Information
As a DBA, one of the things I routinely need to check is how much space is available in my database data and log files. In this post of my ongoing SQL …
SQL Scripts: How To Find Index Usage
This post is part of an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. Why Should I Check Index Usage? …
SQL Scripts: How To Find Index Fragmentation
This is the first post in an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? …