n example for manipulation of the filtered column is applying a function to it, as in F(col1) = 10, where F is some function. There are some exceptions to this rule, but they are very uncommon.
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Applying a function to a filtered column prevents SQL Server from making use of available indices.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/18760/