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)

June, 2008

  • TOP, ORDER BY, and Non-Unique Columns

    One of the comments I accidentally deleted earlier this afternoon posed the following question (paraphrased): I understand that TOP with ORDER BY makes no sense, but what about when I use different values for TOP and I ORDER BY a column that has...
  • DWWTWT?: June 23-27

    The week featured time in the office each day this week. I'm still not up to walking..: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 42 ...
  • DWWTWT?: June 30

    The end of the MS fiscal year and the second calendar quarter feature another drive to work: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 42 ...
  • I'd Much Rather Be At TechEd 2008 Developers..

    .. but my appendix had other plans. I underwent the fabled 0400 Sunday morning emergency appendectomy following a burst on Saturday evening, May 17. Absent a misguided 16-hour attempt to leave the hospital 72-hours post-op (my last gasp at joining you...
  • DWWTWT?: June 2-6

    The week was again non-competitive as my recovery continues its slow, steady pace: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked...
  • DWWTWT?: June 9-13

    The week was once again non-competitive as my recovery crawls along: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked 204...
  • DWWTWT?: June 16-20

    The week featured a brief visit to the office on Wednesday (ride courtesy of my wife Gale, the best and most patient caregiver on the planet) and telecommutes of varying lengths the rest of the week: Commuting Options Selected...
  • Ack! I Just Deleted Four Comments Accidentally!

    If you've left a comment here since June 4th, please repost it with my thanks and apologies. I tried to do a bulk approval and I did a bulk deletion by mistake. One of them was a question about TOP with ORDER BY that I'll attempt to reproduce in a...
  • Blogiversary v3.0

    Yes, I'm cheating a bit by retro-posting this a few days after the fact, but this humble corner turned three years old as of the timestamp on this, its 627th post (other milestone posts here , here , and here ). Given the way life has gone the last...