Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
2025-11-24
4,985 reads
Filtered Index
A Rolling Filtered Index in SQL Server
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
Prevent Duplicate Records in SQL using Filtered Index
In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table.
2024-07-03
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
Alamat BCA KCU Singkawang Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota...
Alamat Kantor BCA KCU Bandar Lampung Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota...
Alamat Kantor BCA KCU JAMBI Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers