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

  • 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...
  • 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...
  • 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...
  • 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...
  • 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.
  • 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...
  • 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...
  • 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...
  • 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...
  • Database Programming: Nearing Capitulation On Optional Parameters

    Adam and Tony both left comments indicating that either flavor of my proposed optional parameter syntax will result in a table scan, and that performance will (to appropriate Tony's characterization) suck. That's quite correct. There's one more syntax...
  • Technical News: The Develop Without Borders Contest

    Word of another great programming contest has made its way to my inbox. Sponsored by Microsoft and HP , it’s called the Develop Without Borders Challenge and it encourages developers and architects to submit a solution design that helps a non-profit...
  • 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...
  • 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...
  • Redmond Raiders Update: Moses Lake, Here They Come!

    A brief update for those of you interested in Babe Ruth basball: Kyle's team, the Redmond Raiders, won the District 3 All-Star Tournament, sweeping three games without a loss. The team will be the 3A representative to the state tournament, which starts...
  • 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 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...
  • Database Programming: No Better Options For Optional Parameters

    Well, the current leg of the great "optional parameter code-off" has been completed. You definitely want to party with me on a national holday. :) Previous posts in this thread (many filled with questionable advice, as least that coming from me) may be...
  • 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
  • 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 ...
  • 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 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 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 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...
  • 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 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...