Ward Pond's SQL Server blog

Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)

July, 2006

  • DWWTWT?: July 31

    The month ends and the week begins with a beautiful day for self-propulsion: Telecommuted: 2 Walked: 17 Drove: 9 Did Not Compete: 8 I've got a couple of commitments this week which might...
  • New SQL Server 2005 Books OnLine Available For Download

    The July, 2006 update to SQL Server 2005 Books OnLine is available here . At the moment, the new version is available only in English. Here's a summary of what's covered: New Conceptual and Task Topics Breaking Changes to Integration Services...
  • Pond's Seventh Law, Applied: Avoiding Random Elegance

    Another application of Pond's Laws comes to light from an exchange on an internal SQL Server discussion list. My good friend and colleague John Huschka, a Senior Software Development Engineer for Microsoft Business Solutions' FRx Software Corporation...
  • DWWTWT?: July 28

    As I hoped, the week ended on a non-combustible note: Telecommuted: 2 Walked: 16 Drove: 9 Did Not Compete: 8 Hope you have a great weekend.. -wp
  • DWWTWT?: July 27

    As predicted yesterday, no after-work commitments had me back on the sidewalk: Telecommuted: 2 Walked: 15 Drove: 9 Did Not Compete: 8 I plan to end the week walking; tune in tomorrow...
  • DWWTWT?: July 26

    A late afternoon appointment in Issaquah meant that I needed to drive to work today so as not to lose half an hour walking back to my car: Telecommuted: 2 Walked: 14 Drove: 9 Did Not Compete...
  • DWWTWT?: July 25

    The heat wave is pretty much an historical reference at this point. It was probably in the low-mid 60s on my walk to work this morning: Telecommuted: 2 Walked: 14 Drove: 8 Did Not Compete: ...
  • DWWTWT?: July 24

    The office move is complete, and the heat wave is slowly dissipating. It was pretty warm at 8 this morning (low 70s) but it wasn't unpleasant morning for a walk: Telecommuted: 2 Walked: 13 Drove: 8 ...
  • Database Programming: Temp Tables or Table Variables?

    On the occasion of this blog's one hundredth post, I thought I'd pass along some information I recently discussed with my youngest cousin, Tom, who is like me an otherwise rational person who's been bitten by the database development bug. In a conversation...
  • DWWTWT?: July 21

    It's 105 degrees Fahrenheit in the shade. What a great day to be telecommuting from a home without air conditioning! Telecommuted: 2 Walked: 12 Drove: 8 Did Not Compete: 8 Happy ninth...
  • Pond’s Eleventh Law Emerges From Reflection Upon The Perils Of Going Fast

    When I first published Pond’s Laws, I promised it would be a living document. Herewith is the first evidence.
  • DWWTWT?: July 20

    As promised yesterday, our office move causes a new category to be introduced to our tally: Telecommuted: 1 Walked: 12 Drove: 8 Did Not Compete: 8 You can probably guess how this will...
  • DWWTWT?: July 19

    For the first time since June 23, I employed an internal combustion engine to get to work today. With an office move scheduled for the rest of the week, there were a few last minute fragile items I wanted to bring home, so: Walked...
  • DWWTWT?: July 18

    It was a little warmer this morning than it was yesterday, but it was still a fine day to leave the car in the garage: Walked: 12 Drove: 7 Did Not Compete: 8 It's been a beautiful summer in the...
  • DWWTWT?: July 17

    Back to work, and back on foot on a crisp morning with high clouds. A nice cool morning to walk to work. Walked: 11 Drove: 7 Did Not Compete: 8 Vacation was wonderful, but it's great to be back...
  • Non-Technical Content: Home From Moses Lake A Day Early

    My final dispatch re: the Northern Washington Babe Ruth 13U Tournament (edited on 18 July to include final result) : The game against Central Kitsap didn't fall the Raiders' way. They fell to a 7-0 deficit after two innings and rallied to within 9...
  • Non-Technical Content: Redmond Raiders Win Thriller

    Another dispatch from the Northern Washington Babe Ruth 13U Tournament.. Last night, the Redmond Raiders came back from a 4-1 deficit to defeat the host team, the Moses Lake Desert Dogs, 7-4. The boys scored three runs in the fifth to tie the game...
  • DWWTWT?: July 14

    Happy 5th Anniversary, Gale!! Bless your heart for letting the boys and me be.. Out and about in Moses Lake.. Walked: 10 Drove: 7 Did Not Compete: 8 Go Raiders! -wp
  • DWWTWT?: July 13

    Out and about in Moses Lake.. Walked: 10 Drove: 7 Did Not Compete: 7 Go Raiders! -wp
  • Non-Technical Content: Raiders Now 1-1 In Tournament Play

    Today's action in the Northern Washington Babe Ruth Tournament saw our Redmond Raiders fall to the Ellensburg Pounders, 12-5. The boys were up 3-0 after the top of the first inning, but the Pounders responded with five runs of their own in the bottom...
  • Optional Parameters: Adam Hopes I'm Joking, But The Joke's On Me

    This is absolutely my last gasp on optional parameters. Adam Machanic left some syntax in a comment here which shows just how far off base my "last gasp" in this post was. My syntax produced 594 logical reads to resolve a query while the equivalent...
  • Non-Technical Content: Redmond Raiders Win First Game

    Frequent visitors to this space will recall that I'm spending the rest of this week in Moses Lake, WA, watching my son Kyle play in the Northern Washington Babe Ruth Baseball 13U Tournament. This afternoon, Kyle's Redmond Raiders played their first...
  • DWWTWT?: July 12

    Out and about in Moses Lake.. Walked: 10 Drove: 7 Did Not Compete: 6 Go Raiders! -wp
  • DWWTWT?: July 11

    On our way out the door to Moses Lake.. Walked: 10 Drove: 7 Did Not Compete: 5 Seven days, with no competition remaing this week.. Go Raiders! -wp
  • Database Programming: One Last Gasp On Optional Parameters

    July 12 update: Everything that follows is WRONG . See Adam's comment and my follow-up . You might think I'm obsessing over this, and you may well be right, but I wanted to make one more comment about handling optional parameters. The issue with...