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: Telecommuted: 2 Walked: 12 Walked to the Bus: 1 Drove: 5 Did Not Compete: 3 That’s an 18% driving rate for the month..  This experiment finally seems to…

0

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’s elevated above the mudpit. …

1

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 been since the end of June that I walked that many days in a row. I hope you and yours have a safe and happy Halloween…

0

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 lead for the first time since September 14.  We’ll see how long it lasts!      -wp

0

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 IT will also be presented in Room 132, 3:45pm-5pm on Wednesday, November 7th  Data Modeling for…

0

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: Telecommuted: 32 Walked: 118 Walked to the Bus: 17 Drove: 118 Did Not Compete: 75 Hopefully…

0

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: 17 Drove: 118 Did Not Compete: 75 Hope your week is going well..      -wp

0

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 for the T-SQL Developer: Insights from Microsoft IT will be presented in room 130, 4pm-5:15pm…

1

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 work over the last couple of days, and I’ve found a new use for a technique…

5

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 that the number of partitions for an OLTP table should…

0