“Dotnet tips, SQL Server tips, Silverlight tips, AJAX tips...”
Read Experts reviews and compare prices to find the right desktop or laptop for you from the huge collection.
If you use ROW_Number for paging (two nested selects), you will find in this article an interesting performance tip, placing a TOP in your inner query makes your query run faster
The author offers a more generic and elegant way to do the trick