Disabling An Index Drops Compression
This post is more of an FYI, and to remind myself in case I run into it again down the road. Here at work we have a very large, very …
Recover Deleted Indexes With SQL Server Metrics Pack
In my latest enhancement to SQL Server Metrics Pack , I added a new feature to the index metrics scripts that automatically generates a CREATE INDEX script and stores it …
SQL Server Metrics Pack Update – September 2019
This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements …
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 …
3 New Open Source SQL Server Projects
Today I would like to officially unveil 3 new open source SQL Server projects that I have on GitHub! I will have upcoming blog posts that discuss each project in …