Description: Providing value through enabling data understanding and effective use
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.