Filtered Index

External Article

A Rolling Filtered Index in SQL Server

  • Article

I recently resolved an issue where a query pulling data from the last 30 days would time out due to the table’s size and the lack of a supporting index. Creating a supporting index is possible, but not ideal; it will be very large and may not be useful for most queries and use cases. I wonder how I could implement a filtered index that follows time and is always limited to the last n days.

2025-09-10

Blogs

Set Theory vs. Batch Mode in SQL Server

By

Set Theory vs. Batch Mode in SQL Server Not long ago,...

Monday Monitor Tips: The Jobs Report

By

A customer wanted a report they could email to their boss about jobs, something...

Automating SQL Maintenance: How DevOps Principles Reduce Downtime

By

In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...

Read the latest Blogs

Forums

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

All the Costs of Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item All the Costs of Downtime

How Well Does the MSSQL Extension in VSCode Work?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Well Does the MSSQL...

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers