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

  • 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...
  • 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...
  • 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...
  • The Start of An Answer For Scott: Temp Tables and Recompiles

    Kimberly Tripp, one of the most incredibly astute SQL poeple on the planet, calls her blog , "Improving *my* SQL skills through your questions". I would never steal her line, but after a bit of research on MSDN this afternoon, I can certainly relate to...
  • "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
  • 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...
  • 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...
  • 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...
  • 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...
  • Data Warehousing: A Open Note To Cousin Tom

    Cousin Tom asks, what makes a good data warehouse?
  • 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...
  • 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...
  • "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,...
  • 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...
  • Non-Technical News: Those Who Forget History..

    A decidedly non-technical discussion.. what makes a good citizen?
  • DWWTWT?: August 31

    The month ends with the automobiles left in the driveway: Telecommuted: 3 Walked: 36 Drove: 12 Did Not Compete: 8 Here are the totals for the month of August: Telecommuted...
  • DWWTWT?: August 29

    Despite a light mist falling this morning (I believe this was our first precipitation on a work day since my first day on the new job), I left the automobiles in their parking spots: Telecommuted: 3 Walked: 35 ...
  • DWWTWT?: August 23

    Internal combustion was indeed avoided this morning: Telecommuted: 3 Walked: 31 Drove: 11 Did Not Compete: 8 We're looking good for the rest of the week. Stay tuned. . -wp
  • DWWTWT?: August 25

    The sun sets tonight on another week of petroleum-free commuting: Telecommuted: 3 Walked: 33 Drove: 11 Did Not Compete: 8 After 11 weeks of this experiment, I've walked to work 60% of...
  • DWWTWT?: August 30

    Well, it was a bit of a perfect storm this morning. No, I'm not referring to the light drizzle that was falling. I'm referring to the fact that Zach needed a ride home from football practice just as Gale's doctor's appointment was starting. The only way...
  • 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 28

    My week got off on the "right foot" (and the left, I suppose) for fans of self-propulsion: Telecommuted: 3 Walked: 34 Drove: 11 Did Not Compete: 8 In these parts, this is the last full...
  • 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
  • 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 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...