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

TSQL

Missing row numbers

I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.