A query on the base table used an index it did not own. It was the index on index view of the same table, an interesting observation from an optimization project.
High-Frequency Inserts Without Blocking
High-frequency inserts can stall on the log, indexes, or last-page contention; learn to diagnose the wait and choose targeted SQL Server fixes.
SQL SERVER – Index Seek vs. Index Scan – Difference and Usage – A Simple Note
Index seek vs. index scan: the two ways SQL Server reads data through an index, how they differ, and when each one is used. A simple note.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
Full-Text Search Basics
Full-text search basics explains catalogs, full-text indexes, CONTAINS, and LIKE so SQL Server searches match the question and the data.
SQL SERVER – Maximum Number of Index per Table
My TechEd on Road Ahmedabad recap, with 200+ attendees and a quiz, along with a look at the maximum number of index per table in SQL Server.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.