Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

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

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?

Insert without a PK

Filtered Indexes 2

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.

Filtered Indexes

NONclustered 2 clustered

Columnstore Indexes