Subscribe to this blog
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, 552 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, 545 reads
Posted in Dave Ballantynes blog on 1 August 2011