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 ...

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...