Composite Index Keys and searching on secondary key values

In my time as a DBA, one of the most frequent misunderstandings I’ve found is how composite keys work within SQL Server, particularly relating to searches on the secondary key columns.
Continue reading

Advertisements