SQL and the like

Dave Ballantyne's blog. Freelance SQL Server database designer and developer at Clear Sky SQL

Browse by Tags

All Tags » Denali (RSS)
Denali–IIF and CHOOSE
In Denali CTP3 , we have a new of new functions to play with.  For this post, im going to focus on IIF and CHOOSE. The syntax of these are : IIF(<condition>,<true expresssion>,<false expression>) and CHOOSE(<value>,<when...
Posted: Jul 19 2011, 01:30 PM by Dave Ballantyne | with no comments
Filed under:
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...
Denali Paging–Is it win/win ?
UPDATE : 2012-07-26 : My latest commentry of the paging subject can be found here : http://sqlblogcasts.com/blogs/sqlandthelike/archive/2012/04/26/offset-without-offset.aspx I'm not one for automatically poo-pooing new ideas, new practices and new...