September 2009 - Posts

• Speaking at the Orange County SQL Server Professionals User Group

  I will be speaking at the Orange County SQL Server Professionals User Group this Thursday, October 1st, 2009. The topic is “How the Query Optimizer Works”. So if you are in the Orange County or Los Angeles area please stop by and say hello. The meeting Read More... Posted Wednesday, September 30, 2009 12:00 AM by Ben Nevarez | 2 Comments Filed under: Query Optimizer, Speaking, User Group Meetings

• The Missing Indexes Feature

  Since I will be speaking about the Query Optimizer at the coming PASS Summit, I have been preparing my presentation and at the same time blogging about it. This time I will describe the Missing Indexes feature, seen from the point of view of the Query Read More... Posted Friday, September 25, 2009 12:19 AM by Ben Nevarez | 3 Comments Filed under: Indexes, Optimization, Performance, Query Optimizer

• Speaking at Los Angeles SQL Server Professionals Group

  I will be speaking at Los Angeles SQL Server Professionals Group this Thursday, September 17, 2009. The topic is “How the Query Optimizer Works”. So if you are in the area please stop by and say hello.   The meeting starts at 6:30 PM. More details Read More... Posted Monday, September 14, 2009 10:06 PM by Ben Nevarez | 2 Comments Filed under: Query Optimizer, Speaking, User Group Meetings

• How the Query Optimizer Uses Statistics – Part II

  I got a question from a reader of my post How the Query Optimizer Uses Statistics (http://sqlblog.com/blogs/ben_nevarez/archive/2009/09/03/how-the-query-optimizer-uses-statistics.aspx) and I thought that it would be a good idea to post my answer here. Read More... Posted Friday, September 11, 2009 11:32 PM by Ben Nevarez | (Comments Off) Filed under: Query Optimizer, Statistics

• Statistics Used by the Query Optimizer in SQL Server White Paper

  In case you are not aware, the excellent white paper “Statistics Used by the Query Optimizer in SQL Server” has been updated for SQL Server 2008. You can find it here Statistics Used by the Query Optimizer in SQL Server 2008 Writer: Eric N. Hanson and Read More... Posted Friday, September 04, 2009 5:47 PM by Ben Nevarez | (Comments Off) Filed under: Query Optimizer, Statistics, White papers

• How the Query Optimizer Uses Statistics

  This post shows how the Query Optimizer uses statistics to estimate the selectivity of expressions during query optimization. You can also use this as a second part of my last post, The Query Optimizer and Parameter Sniffing. Here I will show you the Read More... Posted Thursday, September 03, 2009 12:00 AM by Ben Nevarez | 4 Comments Filed under: Optimization, Performance, Query Optimizer, Statistics