clustered index seek - Number2 Blog

Browse by Tags

All Tags » clustered index seek (RSS)

SQL Performance - Indexes and the LIKE clause by jnelson

INDEXES AND THE LIKE CLAUSE Often times, people will make the generalization that when you have LIKE in your WHERE clause it won't use indexes. The real answer is a little more complicated than that...

Filed under: SQL, SMS, table scan, clustered index seek, SMS 2003, index, sql 2005, LIKE, web reports, clustered index scan, index scan, wildcard, index seek

Track table growth (or shrinkage) with a SQL job, a table and a multistatement table-valued user defined function by jnelson

THE PROBLEM Sometimes your SMS infrastructure seems to be swimming right along and everything is going right and then something you didn't think too much about happens. You start getting alerts that...

Filed under: SQL, execution plan, table scan, Table size, coalesce, multistatement table-valued function, clustered index seek, UDF, user defined functions, table variable, inline function

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

Browse by Tags

SQL Performance - Indexes and the LIKE clause by jnelson

Track table growth (or shrinkage) with a SQL job, a table and a multistatement table-valued user defined function by jnelson