I’m live blogging the PASS keynote…it’s 8:44 local time.
- Me: Tuesday is #SQLSat shirt day, Wednesday is #sqlkilt day, Thursday is Show Up day. #sqlpass
Here’s the PASS website description of the day 2 keynote …this is the one everyone’s been talking about, the DeWitt keynote. Remember to follow along with the livestream: http://www.sqlpass.org/summit/na2010/livekeynotes.aspx!
Rick Heigis:
Heh, we just applauded the internet.
PASS board of directors is a volunteer board. They keep saying “best ___ EVER”, and I always hear “Best ___ EVAR!!!!” Board Directors are now Douglas McDowell, Andy Warren, and Allen Kinsel.
- RT @wendy_dance: Well deserved kudos for outgoing board member @lyndarab #sqlpass This #passwit is an inspiration!
New event in 2011: The PASS SQLRally, with precons in BI, DBA, De, Prof, and Dev tracks (including Grant Fritchey [http://scarydba.wordpress.com] , Kevin Kline, Patrick LeBlanc, Devin Knight, and more). #SQLRally is now open for you to register. Precon $299, conference $199, or both together for $449 before Dec 1. See www.SQLRally.com
- SQLChicken: Preview Plus package: Summit + 2 precon seminars = $1295, good until Dec. 31st #sqlpass
Wow, next year Summit is October 11-14, with two precon days instaed of one pre and one postcon. Earlybird reg is under $1k. Cool, maybe we’ll be able to hit SQL Connections in November for the first time ever…maybe…
- @AndyLeonard: #sqlpass DVDs available for non-attendees for $395
- @SQLFool: Seriously, folks, you should get the dvd. Just think of all the awesome sessions you missed. #sqlpass
Send questions for today’s keynote using ASKDrDeWitt@SQLPASS.org #sqlpass Kids at home, play along!
Dr David DeWitt: Technical Fellow, Data and Storage Platform Division
- Me: David DeWitt is running out of things to talk about. #sqlpass
- Me: Hah, chart: The Impress Index descends to zero from day 1 to day 3 of #sqlpass
We’re getting art by the SQL Server query optimizer. Every color in the pic represents different parameters in the TPC-H benchmark. Today we’re talking about SQL query optimization (another power lecture). Fundamentals, leaving with an understanding of why optimizers sometimes produce bad plans. Query optimization is harder than rocket science.
100,000 ft view has “magic happens”‘ as the key component.
- KimberlyLTripp: Awesome slide #sqlpass SQL goes in -> magic happens -> awesome query plan comes out! LOL
- MarkGStacey: “Query Optimisation is not rocket science. When you flunk out of Query Optimisation, we make you do rocket science” #SQLPASS
Query 8 of the TPC-H benchmark, there are 22 million alternative ways of executing this query. Cost-based query optimization was invented by Pat selinger in the 70s. This remains the hardest part of building a DBMS. QO transfers queries into an efficient execution plan: parse [into logical operator tree], QO [physical operator], execution. Physical operators = how they do it, e.g. nested loop join, etc.
Example…
