Wildcards II

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.

SOUNDEX

Wildcards

PIVOT Me

Use HASHBYTES to identify changes

Use a hash to identify changes and process just the changed rows.

REGEX

Using Max()

COUNT, COALESCE, ISNULL, DISTINCT

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.