Saturday, December 30, 2006
Friday, December 29, 2006
- don't have enough fuel to get home, so
- i'll stop in Brenham at the Shell gas station
- get fuel
- if busy, move my car to parking spot
- go to restroom
- go to McDonald's to get a milkshake
- ready to make the rest of the trip home without another stop
I do this a lot. I'm wondering, am I weird or is it just a by-product of being in this business too long (or both)? When I got married, in the beginning I would get a bit irritated when my wife and I would have to do some spontaneous shopping. For example, we would be on our way home, and my wife would say "we need some milk, let's get some at Heb". This would cause me to build the execution plan for getting milk:
- walk to back of store where milk is
- get milk (vitamin D added)
- get in line at check-out
- pay and go home
Simple, fast and effective. But regularly my wife would invalidate this carefully constructed plan: "We're here anyway, let's also get some veggies/meat/whatever". Yikes! Not good! You said we we're getting milk, not get groceries (a totally different plan)! Luckily, I've adapted to that. I now allow for the variation in the plan. When we go into a supermarket, I just get a shopping cart by default...
Happy New Year to everybody!
Thursday, December 14, 2006
Some times companies do nice things for folks, like Hertz this week gave me a Mustang Convertible. However they seem to only do this when it's not convertible season. Like this month, December. I'm in Rochester New York with this rather nice car, too bad that I drive into the place I'm teaching at in the predawn hours and back to the hotel after sunset. It has been in the 50s during the day, but I wouldn't know it since I'm in the center of the building with no windows. Oh well, it's nice to have a car with a serious amount of pep in it. Pushing down on the slanted board sure makes this thing go!
Monday, December 11, 2006
Friday, December 1, 2006
The plane was late getting into Dallas, and then we had to de-ice, which apparently is not something they do often at DFW. That took quite a long time, mostly because they didn't seem to have many de-icing trucks. And just to make things interesting it was a CRJ aircraft so I had to plane side check my carry on bag. All this added up getting to MEM with about 20 minutes. And you know it, the gates were on near opposite sides of the airport!
I walked on the plane behind the gate agent who was bringing down the flight manifest, that's really much to close!
But I made a great discovery week .... Tasty Kakes !!! Individual deserts kinda' like Lil' Debbie's. Made locally here in the Philly area very "tasty" no pun intented.
Monday, November 27, 2006
Day 1 of our Optimizing Oracle SQL Intensive course started off with 10 bright-eyed students today in Beaverton, Oregon. This week we're fortunate to be hosted by the Oregon Graduate Institute at their wonderful facility.
Things got off to a good start and day 1 ended with one student commenting "boy...my head is full"! And it's only day 1!
Monday, November 20, 2006
Of course, they probably didn't need to upgrade their servers either....it was probably just bad SQL!
[Dilbert comic strip from Aug. 5, 2006 - copyright Scott Adams, Inc.]
Thursday, November 16, 2006
Now...if the course I'm developing ends up having lots of coffee and jazz references in the notes, you'll know where they came from!
Wednesday, November 15, 2006
Call me crazy, call me mad, but somehow I don't see the point. These queries would result in reports of thousands of screens long! I can't believe that's really what the business users want. So apart from trying to speed up the queries, we'll ask those business users what it is they really want. Chances are, we can add some default where clauses to these queries so the result sets will end up being a bit more sensible...
Jan van Mourik
Last night I was sitting in the parking lot of the hotel and pulled up Neverlost, I went to Yellow Pages, then Hotels, then Nearest, I picked my hotel. Neverlost said my hotel was 25 miles away. Gee that’s funny I can look out the window of the car and the hotel is RIGHT THERE!
Well at least FedEx knows where my hotel was. The package sent to the hotel for me was here when I arrived as expected.
I tried using Neverlost to find a Kinko’s around here, again it was miles off. I wasn’t able to find the place until I asked a local where it was.
The map view on Neverlost does seem to work. And I hope it can find its way back to the airport at the end of the week.
Tuesday, November 14, 2006
Production Environment 1
OLD -- Elapsed: 00:00:07.01
NEW -- Elapsed: 00:00:00.06
Production Environment 2
OLD -- Elapsed: 00:00:19.06
NEW -- Elapsed: 00:00:01.06
Notice in the test output below how the LIO statistics for both the original and new SQL tests are identical. The plans are very similar as well. But, the big difference appears to be the time saved by removing the extra work required by the sum(case...) constructs.
The moral of the story here is that when writing SQL, you need to consider many different things and always make sure that you attempt to write the code to do the least amount of work possible to get the result you desire.
I say this to students in class all the time - Don't do work you don't have to do!
You can find the details of the tests (conducted on a 10.1 database) here.
Monday, November 13, 2006
This blog will be mostly about life on the road, people we meet and things we learn along the way. It's pretty amazing at how much we learn as we teach and we thought it would be fun to share some of the adventures with you.
So, come along for the ride!