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

Archives: August 2011

Unleashing my inner Viking, SQLBits and more…

In case you didn't know SQLBits 9 ,”Query across the Mersey”, is taking place in Liverpool from September 21st to October 1st.  3 days of the usual excellent quality presentations, networking interspersed with the odd beer or two should all make for an informative and entertaining conference.  Rumor has… Read more

1 comments, 1,553 reads

Posted in Dave Ballantynes blog on 31 August 2011

Rolling your own index lookups

Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to produce efficient and robust SQL code.  One of the areas we looked at was the “Index Lookup” aka “Bookmark Lookup”.  An index lookup occurs when a non-clustered index seek is… Read more

2 comments, 1,323 reads

Posted in Dave Ballantynes blog on 1 August 2011