Execute T-SQL Scripts in Parallel

Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.

LIKEable Brackets

SQL 2008 T-SQL

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.

cast, convert and float!

SQL Joins

This article describes Join feature of SQL Server.

Unknown NULLs

T-SQL Best Practices – Part 2

Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).

Stored procedures

Celko's Summer SQL Stumpers: Prime numbers

Our first Stumper sees Joe Celko providing a conundrum with a prize for anyone who can come up with a better solution than he can.