An index hint lets you force SQL Server to use a specific index in a query. I show the WITH (INDEX()) syntax with examples, and why it is for special cases only.
SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
An observation from my query optimization work: the effect of clustered index on a nonclustered index, shown with a sample table and execution plans.
SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY
Two simple AdventureWorks queries return the same rows in a different order without ORDER BY. I explain why that order is never guaranteed.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
SQL SERVER – Guidelines and Coding Standards Part 1
Guidelines and Coding Standards Part 1: Pascal naming for tables, and naming patterns for stored procedures, triggers, indexes and keys.
SQL SERVER – 2008 – Interview Questions and Answers Part 4
SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 – Interview Questions and Answers Part 3
SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.