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

T-SQL

T-SQL Output Clause

Dynamic SQL