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

T-SQL

T-SQL Output Clause

Dynamic SQL

Temporary objects

The SQL of Scrabble and Rapping

In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.

Using T-SQL to Transform XML Data to a Relational Format

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.

Implementing Most Recently Used Lookups

This script will adapt ordering of look-up lists by foreign key usage.

Riddle Me This

Store Procedure Output in a Table

This script show a demonstration of how to interst tore Procedure Output in a Table.