Category: Dev

Applied SQL: LIKE ‘whatever’

Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches a specified pattern. A pattern can include regular characters and wildcard characters.” That makes it pretty darn useful, say, when we’re searching for all product reviews with the word “worst” in it: SELECT ID, Comments […]

Parameterization – A quick note on a CSS SQL article

I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a look. In short, it outlines a customer performance issue caused by a change in the query plan – from parameterized to unparameterized – and a few considerations on resolving it. Concepts worth digging into that […]

“Unraveling Tangled Code” recording and downloads!

Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV!  You can get the slide deck and demo code here. This session stemmed from the recurring nightmare that is undocumented, unsupported code that we SQL folk are supposed to magically […]