So I heard a rumor, that Linq did some pretty need things with pushed up against SQL Server with regards to doing smart and efficient server side pagination of your queries. I wanted to play around with things and see what I could discover… The Setup I created a simple data table, called.. TestData. CREATE TABLE [dbo].[TestData]( [Id] [int] IDENTITY(1,1) NOT NULL, [TestStringIndexed] [varchar](50) NOT NULL, [TestDateIndexed] [datetime] NOT NULL, [TestNumberIndexed] [int] NOT NULL, [TestStringNonIndexed] [varchar](50) NOT NULL, [TestDateNonIndexed] [datetime] NOT NULL, [TestNumberNonINdexed] [int] NOT NULL, CONSTRAINT [PK_TestData] PRIMARY KEY CLUSTERED ( [Id]...