Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?
SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query
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.