T-SQL

Comparing Stored Procedures, Part 2

Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures

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.