Wildcard

Using "Multiple Assignment Variables" for a Generic Compare Data Script

Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.

Sound Off with Soundex

In this article, learn how to use phonetic algorithms such as soundex to make looking up names faster, easier, and more reliable.

Predict output

Script to get Server Info

This script will gather a number of Server Information items that are useful in baselining a SQL Server.

usp_TransposeNRows

Stored procedure to transpose the first N rows of a specified table

Caution with EXCEPT

The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.

Exec on Linked Server

A Genetic Algorithm Sample in T-SQL

Bill Talada brings us an interesting use of T-SQL. Imagine you have a robot moving around a grid and it needs to complete various actions. How do you find the smart robots across many generations?

Optimising “Ends With” searches with REVERSE

A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text