Clustered Index Sql Server 2008. Where name like @query + '%' escape '\' order by this causes a clustered index scan. Also, watch our youtube video on sql tutorial for beginners to get your fundamentals correct.

Just a correction to the last post. If ignore_dup_key was specified for the index and an insert statement that creates a duplicate key is executed, sql server issues a warning and. And a sort operation is used in the execution plan instead of the clustered index.