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
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
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Hi everyone I have a 1000 line SQL query that is too long to...
hi, now and then i want one connection in my ssis pkgs to use...
Comments posted to this topic are about the item AlwaysON health check alerts