Fyi, this is my execution plan for the smart filter query:

StmtText                                                                                                                                   

-------------------------------------------------------------------------------------------------------------------------------------------

  |--Bookmark Lookup(BOOKMARK[Bmk1000]), OBJECT[Northwind].[dbo].[Customers]))

       |--Index Scan(OBJECT

Please look again . The code I posted does an index scan on the City index. The primary key is CustomerID. The statistics must...

Note that it has nothing to do with the fact that it's an integer ID btw. Because we're looking for CustomerID, which is the clustered index, and every non-clustered index...

This technique, although interesting, should be used sparingly as it affects performance. The optimizer will perform full table scans on all tables that have a smart filter on them. Therefore,...

Although an interesting technique, from a database performance point of view, this is not a very good idea. SARGs are turned into non-SARGs, so indexes won't be used (for an...

Or you could use RIGHT(Field, LEN(Field) - 2)

Note that DATALENGTH() will you give you twice the number of characters for unicode columns (i.e. it returns the number of bytes). LEN()...