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

Advice I Like: Ranch Rules

By

Leave a gate behind you the way you first found it. – from Excellent...

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

By

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...

Three Ways to Use Snowflake Data in Microsoft Fabric

By

Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...

Read the latest Blogs

Forums

25 Years of SQL Server Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item 25 Years of SQL Server...

The Decoded Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Decoded Value

Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS

By Sujai Krishna

Comments posted to this topic are about the item Deploying SQL Server Developer Edition...

Visit the forum

Question of the Day

The Decoded Value

In SQL Server 2025, what is returned from this code: 

DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000)));
SELECT BASE64_DECODE(@encoded)

See possible answers