TSQL

Comparing Stored Procedures, Part 1

Provides quantifiable comparison of two stored procedures

SET Functions

Date Functions

SQL Function : Find ‘X’ Business Days in the Future

Many of us deal in date calculations and separating business days from calendar days is always a challenge. New author J Gravelle brings us a new article that talks about this subject as a way of ensuring SLAs are met.

Data Length

Calculate Distance in Miles from Latitude and Longitude

A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.

Hierarchies in SQL

One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.

Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

Lynn Pettis gives us a look at a new way to solve a T-SQL problem.

IDENTITY_INSERT