blogs.conchango.com

In response to my recent post about analyzing query performance in SQL server 2005, my colleague Mr Rowland Jones emailed me a couple of additional points around best practice, which will further aid query performance. Here are the points he makes (in his very own words) Owner Qualification When writing the table names in your queries it is ...

Sometimes I will be writing a query and will be faced with the option of writing it in a number of different ways, each of which will give me the result I’m looking for, and the question I always ask is which is most efficient? Now ‘most efficient’ is an ambiguous term to an extent, because we could mean fastest run time, or ...