T-SQL Best Practices

This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.

Indexed view

Intersect, Except, Union, All and Any

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.

Identity_column

Top five tips for SQL Server developers

Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.

SUBSTRING

int & char

10+ tips for working smarter with SQL

The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started

Limit Groups by Number Using Transact-SQL or MS Access

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.

Inequality!