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)

September, 2006

  • Database Programming: A Prime Number Contender From Down Under

    Denis' Prime Number Challenge just won't die. I think this topic has spurred more dialog than any other in this blog's 15-month, 180-odd post history. Just imagine if I could've harnessed this global outpouring of SQL skills for something with commercial...
  • DWWTWT?: September 29

    As predicted yesterday, September ended on a telecommuting note: Telecommuted: 4 Walked: 53 Drove: 14 Did Not Compete: 9 Here are the totals for the month of September: ...
  • DWWTWT?: September 28

    Yet another near-80-degree day; who could pass up a "long walking commute" on a day like this? Telecommuted: 3 Walked: 53 Drove: 14 Did Not Compete: 9 Tomorrow is looking like a telecommuting...
  • DWWTWT?: September 27

    Another near-80-degree day, another "long walking commute" this morning: Telecommuted: 3 Walked: 52 Drove: 14 Did Not Compete: 9 Tune in tomorrow to see if I can keep this up.. -wp
  • DWWTWT?: September 26

    Yesterday , I said It's supposed to be sunny and in the 70s all week 70s? Try 80s! In Seattle in September! While a top-down internal combustion experience is certainly tempting, I took a "long walking commute" this morning: Telecommuted...
  • Technical News: Windows Vista September EDW Now Available

    I spent my lunch hour today upgrading my laptop from Windows Vista RC1 to the latest EDW (External Developer Workstation) build, build 5728. You can get the new build in the following languages: English German Japanese I've been running...
  • DWWTWT?: September 25

    On Friday , I said With any luck, we'll break 50 on Monday Well, it's Monday and I'm feeling lucky : Telecommuted: 3 Walked: 50 Drove: 14 Did Not Compete: 9 It's supposed to...
  • Database Programming: Closing The Door On The "Discredited" Prime Number Tangent

    One more PDA-incompatible post: lessons learned from "discredited" prime number syntax
  • Database Programming: Sunday Night Prime Number Update

    Our blogging site is going to go dark in an hour or so for a software upgrade, so I won't be able to post my full findings tonight. What I can say is that, based on the current "rules of engagement" (i.e., the timer starts when the tables are populated...
  • Database Programming: Denis' Prime Number Challenge: A New Leader

    Well, folks, there's a new sheriff in town.. this is a continuation of a conversation here and here . I've tweaked Hugo's syntax to further filter the initial seive population (similar to the pre-filtering present in the discredited tangent ). Where...
  • Database Programming: Denis' Prime Number Challenge: Fourth Place Finisher

    Hugo Kornelis posted a wonderful reply on his blog to the Prime Number Challenge, which runs in 9.3 seconds on my laptop. Denis posted his solution in a reply on Hugo's blog ; Denis' solution runs in 6 seconds . WOW! Perhaps this isn't such a crazy...
  • Database Programming: Denis' Prime Number Challenge

    I answer Denis' challenge with another post to refrain from downloading to your mobile device.
  • DWWTWT?: September 22

    The week ended with a "long walking commute": Telecommuted: 3 Walked: 49 Drove: 14 Did Not Compete: 9 With any luck, we'll break 50 on Monday, the 76th working day of this experiment...
  • DWWTWT?: September 21

    Today was the annual Microsoft Company Meeting at Safeco Field in downtown Seattle. This, combined with the fact that I needed to join my wife and son for some family business in the University District, rendered walking highly impractical: ...
  • Database Programming: Set-Based Update -- Hugo's Syntax Outperforms Shaun's; Ward Tweaks Hugo's Syntax Even Further

    A long post continuing last night's discussion regarding the generation of 1M GUIDs. I'm not sure I'd download this one to your PDA...
  • DWWTWT?: September 20

    Despite a light drizzle this morning, I braved the elements: Telecommuted: 3 Walked: 48 Drove: 13 Did Not Compete: 9 Tomorrow's activities are likely to involve an automobile.. -wp
  • Database Programming: Game, Set, Match -- Why Writing Code In Transact-SQL Is Different Than Writing In A Compiled Language

    More tidbits from an internal discussion.. it'll take us awhile to get to the answer to the titular question; hopefully you'll find this a worthy journey. Mike asked, in a nutshell, why this batch is taking so long to run: SET NOCOUNT ON DECLARE...
  • Welcome Back, Peter Gammons!

    I haven't subjected you to a baseball post in awhile . Don't worry, I'll be brief.. I can't let the day pass without noting that the great Peter Gammons has returned to his nonpareil column (link requires subscription) on ESPN.com after his health...
  • DWWTWT?: September 19

    There was a great deal going on today that didn't have much to do with work. I had to give my teenagers a ride to school this morning; I had a doctor's appointment at 12:15, and Kyle had his first basketball game of the season this afternoon. All that...
  • Made In Express Contest Winners Announced!

    Yes, the winners are in ! The Made In Express contest has announced its Grand Prize , First Prize , and Community Choice award winners. Congratulations to Ernie Hall , Ali Khalid , Jonas Martinsson , and Sanchez Roman Canlas !
  • DWWTWT?: September 18

    Our freakishly dry summer is definitely a distant memory now. It was raining hard enough this morning to cause water to puddle on the sidewalk, but I walked through it undaunted: Telecommuted: 3 Walked: 47 ...
  • DWWTWT?: September 15

    Autumn continues to make itself felt in Western Washington, but not with sufficient vigor to discourage a walk to work: Telecommuted: 3 Walked: 46 Drove: 12 Did Not Compete: 9 I was...
  • DWWTWT?: September 14

    The meteorologists were right yesterday , as this morning's options presented a new benchmark in the history of this project: plans to walk to work combined with non-trivial rainfall. Out came the raincoat and the walking shoes.. Telecommuted...
  • DWWTWT?: September 13

    There was definitely a touch of fall in the air this morning; a light mist was falling and it was a good ten degrees cooler than yesterday. After weighing his options very carefully, Alex invited me to join him on his walk to school, so this morning was...
  • DWWTWT?: September 12

    A brisk, sunny morning combined with my grandson's continuing desire to walk to school by himself caused me to roll out my foot-based "short morning commute": Telecommuted: 3 Walked: 43 Drove: 12 ...