I turned up expecting a talk on SQL versus SQLCLR (I thought this may unearth some good arguments on why I should ever consider using the later) but this had been replaced by Rob’s Designing for simplification and it turned out to be one of my favourite sessions from SQLBits 09.
After starting the talk by demonstrating a true gift for languages by speaking a little but near perfect, Welsh (he must have had some home tutoring!) Rob took us through a number of techniques that allow the query optimiser to do its job and magically removed those pesky expensive plans.
Rob discusses some of these on his blog:-
I have recently been involved in a project where the design of a reporting database consisted of a layered structure of queries (sp’s, views, functions). His design tips challenged a number of our ideas and meant I took away many valuable techniques just from this quick hour long session.
Those of you who know Rob Farley will know he’s a funny guy with an enormous armoury of shockingly bad jokes. I quite like bad jokes so found that this complimented his laid back presentation style and made for a very entertaining and engaging session.