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)

October, 2007

  • Database Programming: Why I, Like, May Never Write Another LIKE, Like, Ever Again

    [ UPDATE 30 October 2007 : There are significant ambiguities in this post which are addressed in the comments and in this follow-up , which I recommend reading after you've read this post and its comments. -wp] I've been doing some performance tuning...
  • Update/Clarification: I Might Start To, Like, Like LIKE..

    .. but it's got to have a COLLATE with it. A couple of updates are necessary to my recent post on LIKE, PATINDEX, and COLLATE . A bit of this is covered in the comments to the original post, but I'd like to tie it all together and make sure that it...
  • See You Even More In Barcelona: Two Additional Chalk Talk Sessions Added

    I'm pleased to report that the organizers of TechEd have scheduled repeat offerings of two of my sessions (so much for my earlier belief that the schedule was finalized *grin*): Set-Based Thinking for the T-SQL Developer: Insights from Microsoft...
  • See You In Barcelona: Schedule Finalized For TechEd Developers 2007 Chalk Talks

    The PowerPoints are done. All of the demos save one are complete. A few days ago, the final pieces fell into place when the final schedule for TechEd Developers 2007. I'll be delivering the following "chalk talk" sessions: Set-Based Thinking...
  • Microsoft TechEd Developers: New Session Added

    Late-breaking news related to my earlier announcement that I'm presenting at next month's TechEd Developers 2007 in Barcelona: It's my pleasure to announce that I'll be moderating a third session, largely demo-oriented, called Version-stamping of Database...
  • There's More To GO Than Meets The Eye

    This little tidbit originated with Kalen Delaney , and was forwarded to me by Lance Larsen, a colleague here at Microsoft. I've verified that this works in all versions of SQL Server since SQL Server 2000 SP4. Here's Lance's note: I did...
  • Lubor Offers a Wonderful Synopsis of Partitioning

    One of the best parts of my current job is that the email distribution lists I'm on allow me to be a "fly on the wall" for some very interesting, educational conversations. Terry started this one off by asking a question: I’ve heard it recommended...
  • DWWTWT?: October 15-19

    Monday was a telecommuting day, Tuesday I drove due to after-work commitment, Wednesday I walked to the bus in order to go to the passport office in downtown Seattle, and Thursday and Friday I walked to work: Telecommuted: 32 ...
  • DWWTWT?: October 22-23

    Yesterday I had to take the van into the shop, so it was a driving day. Today was a beautiful walk through a very rare mid-70s sunny day in late October: Telecommuted: 32 Walked: 115 Walked to the Bus: ...
  • DWWTWT?: October 24-26

    Remember that warm, sunny morning I described on Tuesday ? Well, Wednesday, Thursday and today were all walking days with steadily decreasing temperatures; I actually walked through frost this morning! These results have Walked back in a tie with Drove...
  • DWWTWT?: October 29

    This morning I walked through a misting drizzle: Telecommuted: 32 Walked: 119 Walked to the Bus: 17 Drove: 118 Did Not Compete: 75 This puts Walked back in the...
  • DWWTWT?: October 10-12

    Wednesday and Thursday I drove to work; Friday was a telecommuter: Telecommuted: 31 Walked: 112 Walked to the Bus: 16 Drove: 116 Did Not Compete: 75 Hope your...
  • DWWTWT?: October 4-5

    Thursday I walked, and Friday I will be noncompetitive due to family issues: Telecommuted: 30 Walked: 112 Walked to the Bus: 16 Drove: 114 Did Not Compete: 73 ...
  • DWWTWT?: October 8-9

    Monday and Tuesday were both noncompetitive due to family issues: Telecommuted: 30 Walked: 112 Walked to the Bus: 16 Drove: 114 Did Not Compete: 75 Hope your...
  • DWWTWT?: October 1-3

    The month and the week started with a Monday drive and Tuesday and Wednesday walks: Telecommuted: 30 Walked: 111 Walked to the Bus: 16 Drove: 114 Did Not Compete: 72 ...
  • DWWTWT?: October 30

    Another walking day on a brisk (mid-30s) morning: Telecommuted: 32 Walked: 120 Walked to the Bus: 17 Drove: 118 Did Not Compete: 75 That's six in a row! It's...
  • DWWTWT?: October 31

    Another walking day on a brisk All Hallow's Eve: Telecommuted: 32 Walked: 121 Walked to the Bus: 17 Drove: 118 Did Not Compete: 75 The October tally: ...