SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2010

Denali Paging–Key seek lookups

In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali.  On reflection,  I think i may of been a little unfair and should of continued always planned to continue my investigations to the next step.

In… Read more

0 comments, 663 reads

Posted in Dave Ballantynes blog on 19 November 2010

Denali Paging–Is it win/win ?

I'm not one for automatically poo-pooing new ideas, new practices and new technology.  Rather I like to take a measured view and try to evaluate based upon merits.

One of the new features in Denali is paging which is now supported by the FETCH option of the ORDER BY clause. … Read more

3 comments, 777 reads

Posted in Dave Ballantynes blog on 10 November 2010