SQL Server Code,Tips and Tricks, Performance Tuning

SQL Server MVP Erland Sommarskog has updated his Dynamic Search Conditions in T-SQL article on 2006年12月27日.

Here is what is new

Added a section on a new fascinating hybrid method built on inline table functions, discovered by SQL Server MVP Marcello Poletti.
Put back the section Using EXEC() from the appendix.
Added new section When Caching Is Really Not What You Want.
Some general review on comments of performance.

So what are you waiting for? It is a new year and there is new stuff to read.

Dynamic Search Conditions in T-SQL

And yes I will post my new years resolutions sometime this week