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)

August, 2006

  • Database Programming: Mixing TOP With UNION

    I'd like to share yet another interesting conversation from an internal discussion list. Michael sent a query that was producing inconsistent results: select TOP 35 1 AS [PRECEDANCE] , W03a . CRDATTIM , W03a . RECORDCD , W03a . CRNODE , W03a . PRTY...
  • Better Living Through Technology

    My friend John Huschka has jumped into blogging with both feet, and it's a wonderful thing to see. He even got a shout-out from Bob Beauchemin during his first week.. pretty darn cool! What's almost as cool for me is that in John's latest post lies...
  • Approaching A New Vista

    It's a red letter day for me.. After more than seven years with Microsoft, the company has at long last purchased a laptop for my business use. Not only does this mean that my "personal" laptop will now be passed to my exceptionally patient spouse...
  • Scott's Answer, Completed: Temp Tables and Recompiles In SQL Server 2005

    When I posted yesterday on this topic (first broached here ), I'd found some good information pertinent to SQL Server 2000 in Tom Davidson's MSDN article . However, at that point I hadn't had much luck finding the equivalent information for SQL Server...
  • Baseball Challenge 2006: Another Chance To Give Back

    If this post looks familiar to long-time denizens of this space, it's most likely because you read this one last year. What follows is a shameless solicitation, directed towards my friends and colleagues in the Puget Sound region and throughout the...
  • SQL Server 2005 Cumulative Hotfix Download Available

    I'm not sure how I missed this one.. A cumulative hotfix package (build 9.0.2153) has been released for SQL Server 2005 SP1. A full description of the fixes as well as instructions for downloading and applying them may be found here . The SQL development...
  • "Investigative Journalism" At Microsoft

    This is pretty funny.. A friend alerted me to the fact that Microsoft Recruiting recently teamed with The Daily Show 's Ed Helms to produce an "expos é" of Microsoft. Check it out via Windows Media Player here . -wp
  • DWWTWT?: August 16

    Yesterday's late-breaking after-work commitment is today's after-work commitment; since we will be with out-of-town colleagues, I'll need to give someone a ride to dinner in the MG : Telecommuted: 3 Walked: 26 ...
  • Community Voting Is Open In The Made In Express Contest

    I've previously blogged on this contest in March and in June .. and now the finalists are ready for your consideration. Twelve projects -- including a personalized print newspaper/magazine, an all-terrain self-maneuverable robot, and an X-10 smart...
  • Database Programming: A Brief Note On The Second OPENROWSET Trick

    Back in March, I presented the " second OPENROWSET trick ", a technique for loading a flat file into a single column of a single row of a table. In researching a question posed by Rob Jarratt of Microsoft Consulting Services in the UK, I discovered...
  • "Sharing Customer Pain" At Microsoft

    On the heels of yesterday's Ed Helms link , here 's another humorous Microsoft video (low bandwidth here ; high bandwidth here ) outlining the implementation of our new "We Share Your Pain" program. If anybody tries to bring me a new office chair,...
  • Database Programming: One More Point On Recompilations and Temp Tables

    Scott Whigham left a very generous comment on my last post on recompilations and temp tables. Within that comment he made an excellent observation that I don't want you to miss: One thing you might mention with respect to using temp tables and/or...
  • DWWTWT?: August 17

    Since tonight's after-work commitment doesn't kick in until 8:30 and the weather continues to be warm and dry, the MG went back in the garage and my walking shoes came back out: Telecommuted: 3 Walked: 27 Drove...
  • DWWTWT?: August 18

    As our remarkable string of beautiful summer weather continues, the walking shoes were out in force: Telecommuted: 3 Walked: 28 Drove: 11 Did Not Compete: 8 The weekend's plans include...
  • Baseball Challenge Update

    The 3rd Annual Baseball Challenge, for the benefit Cocoon House and the Ronald McDonald House of Western Washington , took place yesterday at Everett Memorial Stadium. The Cocoon House team won again this year, 11-5, despite my contribution of an 0-for...
  • DWWTWT?: August 21

    Another beautiful day in Western Washington: Telecommuted: 3 Walked: 29 Drove: 11 Did Not Compete: 8 The gig and the ballgame were both fantastic. . -wp
  • DWWTWT?: August 22

    It was a little brisk this morning (fall is definitely in the air), but not nearly bad enough to discourage a morning strole: Telecommuted: 3 Walked: 30 Drove: 11 Did Not Compete: 8 ...
  • DWWTWT?: August 1

    The new month begins with a plethora of after-work commitments. While the weather is ideal for self-propulson, my schedule dictates the employment of internal combustion: Telecommuted: 2 Walked: 17 Drove: ...
  • DWWTWT?: August 2

    Another in a string of crisp mornings here in Redmond. We are very fortunate to have good walking weather while the rest of the country is sweltering: Telecommuted: 2 Walked: 18 Drove: 10 Did...
  • A Shiny New Corner of The Blogosphere

    All I did was ask a question, honest.. When I was vetting my recent post regarding database design issues, I innocently asked my friend John Huschka if he had a URL he'd like me to link to his name when I cited it. Somewhat sheepishly, he replied he...
  • DWWTWT?: August 3

    Another beautiful morning; another fine day for the car to stay at home: Telecommuted: 2 Walked: 19 Drove: 10 Did Not Compete: 8 Tomorrow will hopefully come out the same way! -wp
  • DWWTWT?: August 4

    There's nothing quite as beautiful as summer in the Pacific Northwest. Another crisp morning followed by an 80 degree afternoon: Telecommuted: 2 Walked: 20 Drove: 10 Did Not Compete: 8...
  • Business Intelligence Is *Not* An Oxymoron

    One of the wonderful things about my new position is that it provides a far different perspective on SQL Server than my old gig did. There's certainly great honor in building OLTP systems, but there's also a lot more going on in the world! Apropos...
  • DWWTWT?: August 7

    There's no better way to begin the day after your birthday than by walking to work on a beautiful summer morning: Telecommuted: 2 Walked: 21 Drove: 10 Did Not Compete: 8 Happy fifth...
  • DWWTWT?: August 8

    Another day, another stroll down 156th Ave. NE: Telecommuted: 2 Walked: 22 Drove: 10 Did Not Compete: 8 Hopefully I'll be able to keep this going tomorrow.. -wp