This blog covers one of the alternative solutions for dealing with tasks that require fetching and manipulating large amounts of data from the database. Of course, you can always rely on standard SQL scripts, but I feel that this approach allows for more flexibility.

How to optimize your slow SQL full text index query that uses a combination of LEFT JOIN and OR operators. A simple switch to the EXISTS operator will make all your performance problems disappear in a moment.

This tutorial will teach you how to write a custom SQL Server function for parsing delimited strings. It is particullary useful if you are passing a parameter that contains multiple string values to be used as a filter for “IN” expression in SQL.