left, right and %

@@CPU_BUSY

Operators

There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.

TSQL

NEW?

Dynamic SQL Merge

This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.

Annoying NULLs

Automatic Full Parallel Processing of Hierarchical SQL Queries

Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.

Insert Commas Into Number String

Function to take a number as a string and return it with commas separating thousands, millions, etc.