Index Basics: Find Tables That Do Not Have A Clustered Index
In a previous Index Basics post we went over the importance of having a Clustered Index on your tables, and we learned that SQL Server will automatically create a Clustered …
SQL Scripts: How To Change The Owner Of A Database
Sometimes it becomes necessary to change the owner of a database. When a database is first created, SQL Server likes to set the owner of that database to the login …
SQL Scripts: How To Check Logins And Permissions
Security and permissions are a big part of a DBA’s job, and being able to find out things such as who has elevated login permissions, or when the last time …
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? …