How to develop TSQL Code

The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored procedures in TSQL. Phil Factor is well-known for his more lengthy and complex stored procedures, so we asked him to explain in more detail how he goes about developing things without the comfort of Visual Studio.

The RECOMPILE Options

This artcle attempts to differentiate between the uses of WITH RECOMPILE and OPTION (RECOMPILE) features.

Whether to use UNION or OR in SQL Server Queries

Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database

Top 10 Index T-SQL Statements That SQL Server DBAs Should Know

Indexes speed retrieval of rows from database tables or views. Here are the top index-related T-SQL statements that SQL Server DBAs should know.

Optimizing a cursor based routine – Part 2

In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.

Optimizing a cursor based routine – Part 1

Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.

SELECT and WHERE without FROM

Date Time range

AVG function

Using a Variable for an IN Predicate

How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.