danthedataman.com

November 11, 2010

Query Optimization by David DeWitt at SQLPASS: Awesome!

Filed under: SQL Server — Dan @ 12:37 pm

Wow!  Amazing to listen to such an expert in the database technology field.  He presented way way more than I could possibly process this morning.  His keynote should be posted here later today.  David works at Microsoft Jim Gray Systems Lab in Wisconsin.  Here is the slide deck from his presentation:

“Query Optimization is not rocket science.  When you flunk out of  query optimization, we make you go build rockets.”  After getting a little visibility today into this field, I believe it.  Wow!

Takeaway for me was the importance to query optimization of updating statistics.  As I deal mostly with data/reporting/BI, I either forgot that, or never grasped the connection.  But David’s presentation today really opened my eyes to the need to make sure statistics are being updated.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: