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...
  • "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
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Data Warehousing: A Open Note To Cousin Tom

    Cousin Tom asks, what makes a good data warehouse?
  • 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 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...
  • 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 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 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 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 ...
  • 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 24

    Another brisk morning, another day for the MG to stay in the garage: Telecommuted: 3 Walked: 32 Drove: 11 Did Not Compete: 8 If I can keep this up, we'll have another internal-combustion...