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 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? …
Persist And Aggregate Index Stats Across Server Restarts
(This script is part of my SQL Server Metrics Pack project that is now available on GitHub. If you like the code below and find it useful, I encourage you to check …
Discover Which Deprecated Features Are Being Used
With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled …
List All Foreign Keys Referencing A Table In SQL Server
There may be times that you need to get a list of tables that have foreign key constraints back to a table that you’re working on. Fortunately, SQL Server has a built …
Checking The Status Of Email Sent From SQL Server
When sending email via sp_send_dbmail, SQL Server will log the status of each message processed by Database Mail. Below is quick list of Database Mail Views you can query to …