Category Archives: SQL Development

Filtered Index on NULL values is still doing a Key Lookup

Posted on September 8, 2019 by uday arumilli

“Filtered index” is really useful when you want to customize and narrow down the data usage and it works like a magic with the minimized index maintenance cost.
When you are creating a filtered index on IS NULL condition, be aware that we need to include the same column. Continue reading →

Posted in Performance Tuning, SQL Development | Tagged , | 3 Comments

SQL Server Performance Tuning using Filtered Covering Index

Posted on September 2, 2019 by uday arumilli

SQL Server Performance Tuning using Filtered Covering Index takes you through a simple scenario where filtered indexes are helpful to improve the performance of frequently used queries. Before starting, I assume that you know “WHAT” a filtered index is or … Continue reading →

Posted in Performance Tuning, SQL Development | Tagged | 1 Comment

Clustered Index On UniqueIdentifier Column

Posted on April 18, 2019 by uday arumilli

Hello all, It’s been a year since we posted a blog. It’s been the busiest year of my life. However, we strongly believe that learning is a journey and it should be a continuing process. Coming to the point, recently … Continue reading →

Posted in Database Design, Performance Tuning, SQL Development | Tagged , , , , | 2 Comments