February 2010 - Posts

• SQL community events in Adelaide this week

  Two events coming up in the next few days in Adelaide. On Monday 22nd, we see the start of the Australian Azure Launch, with David Lemphers coming over. David has a tour, hitting five Australian cities in four days, starting in Adelaide. It should be Read More... Posted Sunday, February 21, 2010 7:17 PM by Rob Farley | 0 Comments Filed under: community, adssug

• Why move a blog?

  A few people have asked why I moved to sqlblog.com (I’ve shifted my blog from msmvps.com recently). After all, I had used msmvps.com since 2006 and written a lot of stuff there (over 400 posts). Whilst I doubt that those posts will be lost, there’s a Read More... Posted Sunday, February 21, 2010 7:00 PM by Rob Farley | 0 Comments

• Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization

  I've moved my blog here (to sqlblog.com), and thought I'd start with a book review. This is a post that I've been meaning to write for some time, and it seems a worthy first post for this new site. I might go through some of my older posts from my blog Read More... Posted Friday, February 19, 2010 5:38 PM by Rob Farley | 5 Comments Filed under: book review

• T-SQL Tuesday #003 (Relationships): The round-up

  (Reposted from my msmvps.com blog ) Lots of blog posts for this month, for the first T-SQL Tuesday to leave the safe-haven of Adam Machanic’s blog . Some people obviously missed out, probably because they don’t read this blog, but I guess that’s the nature Read More... Posted Saturday, February 13, 2010 3:45 PM by Rob Farley | 9 Comments Filed under: sql, t-sql tuesday, community

• A CASE study in SARGability

  (Reposted from my msmvps.com blog ) A recent discussion on Twitter about a query that Denny Cherry was looking at led to this post by Josef Richberg: http://josef-richberg.squarespace.com/journal/2010/1/28/is-a-case-statement-considered-sargable.html Read More... Posted Tuesday, February 02, 2010 8:30 AM by Rob Farley | 0 Comments Filed under: sql, indexing