Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem

Get user table indexes, size and column order

get user table indexes, size and column order

The Importance of Database Indexing

In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.

Columnstore Indexes

Index Fragmentation

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.

SQL Monitor Custom Metric: Possible Duplicate Indexes

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.

Primary key vs Unique key

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100