Saturday, April 19, 2008
"I had always considered myself a decent query tuner/writer. But, I will have to say that I did pick up some nice little tidbits that I have been making use of - like using GROUP BY's in subqueries to force no rewrites, etc. One case I did today was to drop a query from 3.5MM I/O's down to 20K with just such a change. Knowing more about the 10046 trace output is very helpful. I have been helping my main application group in tuning their stuff, most often droping run times in half or better. "
Right on Ken, you go brother!!!
Friday, April 18, 2008
While walking to a sports bar between the 1st and 2nd period, we passed a ticket scalper still trying to unload the last two tickets he had. Long story short, we were in our seats before the puck dropped for about 10% of the pre-game price.
This is turning into a bit of a tradition now.
During my recent visit to Collaborate in Denver, my friends at PIOCON invited some of the Hotsos team to join them at the Pepsi Center to watch Colorado play Minnesota. It was a great game with the home team winning somewhat easily.
Many thanks to Matt Vranicar and Eric Camplin for the invite and a great time - we owe you one!
Friday, April 4, 2008
It was an amazing visit although it seems we were eating Brazilian BBQ non-stop for my entire stay.
I was also able to attend a local Palmeiras soccer game. There is considerable passion surround soccer in Brazil with amazing loyalty to specific clubs. I was almost denied entry into the hotel gym based on wearing the wrong soccer club jersey :-)
If you ever get the opportunity, I would definitely recommend visiting this great country.