SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
SQL Scripts: Find Queries That Have Missing Index Requests
In a previous article, I went over how SQL Server will recommend an index that it believes will help a query run faster, and I showed how to find missing …
SQL Scripts: How To Find Missing Indexes
One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it …
SQL Scripts: How To Find Filtered Indexes
Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …
SQL Scripts: How To Find A Database’s Compatibility Level
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …
SQL Scripts: How To Make Sure Your Backup Is Valid
I recently had a case where I needed to download a database backup to my laptop. It usually takes about 12 hours for this particular backup to copy down, so …
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. If you are interested in code …
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? …