This article is also available as a PDF download. Arranging data in a manner that’s meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more–you need groups you can ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

I need to query against a column which contains build numbers stored as an NVARCHAR.<BR>Sorting works fine until you get into double-digit versions.<BR><BR>This works ...

Four key considerations to keep in mind when you need a database designed for analytical queries of vast quantities of time series data. SQL often struggles when it comes to managing massive amounts ...