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

  • Data Warehousing: A Open Note To Cousin Tom

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

    A decidedly non-technical discussion.. what makes a good citizen?
  • 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 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 ...
  • 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...
  • 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 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 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...
  • 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
  • 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...
  • 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 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
  • 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 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...
  • 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...
  • 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...
  • "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: 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...
  • 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...
  • 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 ...
  • "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
  • 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...
  • 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...