The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.

Copy One Schema to Another Schema

This script copies one object in another multiple schema.

The Right Kind Of Join

Truncate and Delete

Simple Script to Backup All SQL Server Databases

Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.

Simplify Large Queries with Temporary Tables, Table Variables and CTEs

This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.

Hidden RBAR: Counting with Recursive CTE's

"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.

IsNumeric with NULL and Empty String

Exists

Precedence