A few reflections on RBAR by a weary application developer

Follow the guidance of your DBA, but remember, he or she is from another land.

Declare @local variable

Order My Data

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