Jeff Smith Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server

More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions

Fri Mar 30, 2007 by Jeff Smith in t-sql, sports, paging-data, sql-server-2005

I previously wrote about a few of the new features in SQL 2005 and how they can be used to solve some old "classic" SQL problems very easily, and I thought I'd briefly discuss a few more. Read more →

Efficient and DYNAMIC Server-Side Paging with SQL Server 2000

Mon Mar 22, 2004 by Jeff Smith in t-sql, paging-data

(UPDATE:If you are using SQL Server 2005 or above, there is a much easier and more efficient wayto page your data.) Here is a completely dynamic version of my paging technique in the form of a stored procedure. Read more →

Efficient paging of recordsets: SQL Server 2000

Mon Dec 22, 2003 by Jeff Smith in t-sql, paging-data, code-library-sql

Here's the most efficient way that I can think of to return rows @a through @b from a table or query, when each row is ordered and can be uniquely identified by a set of columns. Read more →