Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Sql Saturday #83

imageFrikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point of view about the major features coming in the next version.

The virtual sessions were very popular, we don’t get many good international speakers down in our part of the world and the opportunity to listen to some new speakers was well received.

Benjamin kicked off the virtual sessions with his ’10 query optimiser topics for better performance’. He covered parameter sniffing, showing how the optimiser estimates row counts based on statistics and the sniffed value of parameters, cardinality estimation errors (poor stats or missing statistics) and scalar expressions (hard for the optimiser to guess rows affected). Also discussed were the missing index DMVs and DTA (the database tuning advisor)

My session on poorly performing SQL went very well. It’s a session I’ve done several times and enjoy thoroughly every time. The audience was great, lots of good questions, good comments and good fun. I ran a bit short on time to discuss the fixes for the multiple execution path problem, so I’ll just direct anyone reading to a blog post on it: http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

Big thanks to all the organisers, all the speakers, all the attendees. Special thanks to the international speakers who either stayed up late or woke early to give their sessions.

SQLSat83-1

SQLSat83-2

SQLSat83-3 SQLSat83-4

SQLSat83-5 SQLSat83-6

SQLSat83-7

SQLSat83-8

SQLSat83-9

SQLSat83-10

Comments

Posted by Steve Jones on 10 May 2011

No big loud horns to cheer on the table soccer?

Posted by Jason Brimhall on 10 May 2011

Hey, that's a picture of me (second to last - with my unfinished basement in the background) in the wee hours. Thanks for helping put this show on Gail.

Posted by Jason Brimhall on 10 May 2011

Correction - third to last

Posted by GilaMonster on 13 May 2011

Nah. Vuvuzelas are banned in all civilised offices.

Jason, was a pleasure, though you should be thinking Paul (first pic) and Michael (2nd pic) mostly as they did far more than I did.

Leave a Comment

Please register or log in to leave a comment.