BANGALORE, INDIA: SQL Server 2008 comes with quite a few new features that have more stress on query performance such as filtered index. In this article, we will see how exactly filter indexes help ...

In our Databases we have many nullable foreign keys. In order to save space, we use filtered indexes which exclude all null values. Now if we query like this... SELECT * FROM Foo f JOIN Bar b on ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ramya Krishnamoorthy shares a detailed case ...