I can see how that probably would be a descent way to cut corners if you absolutely had to for performance sake. But in most cases my requirements dictate showing...

I wish it was as simple as that. I cant remember the last time I was able to use a column in a table to sequentially order results. In my...

I dont see how it can. You have to have something to return in the first variable to use as the beginning of your range, and unless its already in...

Of course that example only works in the case where you can use a sequential numeric column like an identity column to pull the page of data you want. In...

In this scenario where there is only one table involved, this probably is a better approach. Rarely is this ever the case for me, so I usually need  joins to other tables...

Here is the problem with that approach though... When you start getting into the 100's thousands and millinos of rows in the table, you are pulling down all of those rows...

For one, you should never return all the columns you need from the CTE, there is no need to return anthing but the row's GUID or Identity column and the...