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, 2006

  • Database Programming: Something Simple That, LIKE, ESCAPEd Me Until Now

    There's no rocket science in this post, just a neat little piece of syntax which has been around for awhile and yet had managed to escape my awareness until Ning asked a really interesting question that I thought I knew the answer to: How do you...
  • Database Programming: Prime Number Methodology

    Rob Farley 's back with two comments in regard to my prime number methodology: Ward - how do you justify having the 'initial fill of sieve' in your tweak of Hugo's? If you pull that stuff out (as per my first post ), it takes much longer. Rob (...
  • Welcome To My Bloo! I'm Afraid I Must Be Going For Awhile..

    UPDATE: Please note that the issue discussed below pertains only to web-based page views, not RSS or Atom feeds Well, the software upgrade we were expecting last week finally went through earlier yesterday morning. Other than some subtle changes...
  • A "Kobiyashi Maru" On The Prime Number Front?

    No less a figure than Louis Davidson has weighed in on the Prime Number Challenge . I left a comment on his blog last week which has yet to be published, so I'll respond to Louis here. Here's the salient part of Louis' post: A friend blogger...
  • From Dad's Bookshelf: More On Prime Numbers

    I'm in western Vermont until Wednesday morning, totally off the grid except for a 56K dialup connection which seems much slower. I'm visiting my father and sister, and I found an item that follows right along with the prime number conversation we've been...
  • DWWTWT?: October 12

    The two hundredth post on this blog finds me back in familiar environs with a "long walking commute" : Telecommuted: 4 Walked: 57 Drove: 14 Did Not Compete: 14 I can't see any reason...
  • DWWTWT?: October 13

    The short (for me) work week ended with a "long walking commute" : Telecommuted: 4 Walked: 58 Drove: 14 Did Not Compete: 14 I hope you have a wonderful weekend.. -wp
  • DWWTWT? October 16

    The work week opened with a somewhat rainy "short walking commute" : Telecommuted: 4 Walked: 59 Drove: 14 Did Not Compete: 14 We should be good for the rest of the week.. stay tuned...
  • DWWTWT?: October 4

    This is a tough day to score. I started out on a "long walking commute," but I needed to spend a few minutes with my grandson's teacher. This led me to realize that, if I walked all the way, I would be late for my nine o'clock meeting. My darling spouse...
  • DWWTWT?: October 5

    Out and about in western Vermont : Telecommuted: 4 Walked: 56 Drove: 14 Did Not Compete: 10 Unless I get a burr under my saddle, these posts will be auto-generated until next Thursday...
  • DWWTWT?: October 6

    Out and about in western Vermont : Telecommuted: 4 Walked: 56 Drove: 14 Did Not Compete: 11 Unless I get a burr under my saddle, these posts will be auto-generated until next Thursday...
  • DWWTWT?: October 9

    Out and about in western Vermont : Telecommuted: 4 Walked: 56 Drove: 14 Did Not Compete: 12 Unless I get a burr under my saddle, these posts will be auto-generated until Thursday.. ...
  • DWWTWT?: October 10

    Out and about in western Vermont : Telecommuted: 4 Walked: 56 Drove: 14 Did Not Compete: 13 Unless I get a burr under my saddle, these posts will be auto-generated until Thursday.. ...
  • DWWTWT?: October 11

    Out and about in western Vermont and eastern New York, and in transit back to Seattle : Telecommuted: 4 Walked: 56 Drove: 14 Did Not Compete: 14 I should be back live tomorrow.. note...
  • DWWTWT?: October 3

    Tuesday brought about a "long walking commute": Telecommuted: 4 Walked: 55 Drove: 14 Did Not Compete: 9 It's still looking good for a three walk week. Stay tuned.. -wp
  • DWWTWT?: October 2

    October begins with the temperatures in the fifties and a "long walking commute": Telecommuted: 4 Walked: 54 Drove: 14 Did Not Compete: 9 There will be a change in pattern later in the...
  • DWWTWT?: October 17

    Another day, another "short walking commute" : Telecommuted: 4 Walked: 60 Drove: 14 Did Not Compete: 14 There might not be a clean walking sweep this week after all.. stay tuned....
  • DWWTWT?: October 18

    I celebrated midweek with a "long walking commute" in the rain : Telecommuted: 4 Walked: 61 Drove: 14 Did Not Compete: 14 More tomorrow.. -wp
  • Better Living Through Tags?

    One of the new features of our recently updated Telligent Community Server software is expanded support for tagging of blog entries. Of course, this feature does little good for you, the reader, unless your humble blogger undertakes to actually tag their...
  • IE7 Is Here!

    This morning, the English version of Internet Explorer 7 for Windows XP was released to the web; it's available for download here . There are myriad improvements over IE6, of which tabbed browsing is just the most obvious. Were I you, I would certainly...
  • DWWTWT?: October 19

    Thursday brought a "long walking commute" in light drizzle : Telecommuted: 4 Walked: 62 Drove: 14 Did Not Compete: 14 Tomorrow is still up in the air, so stay tuned.. -wp
  • DWWTWT?: October 20

    This afternoon, we had a team outing in Seattle. I thought I'd need my car to get there, but I ended up car pooling with a couple of colleagues. So, I could've walked, but I drove: Telecommuted: 4 Walked: 62 ...
  • DWWTWT?: October 23

    It was the coldest morning of the season so far, but that didn't stop me from a "short walking commute" to the first session of the training program we've been building for the last four months: Telecommuted: 4 Walked...
  • The Bloo Is No More.. Long Live The Blog!

    You might recall I mentioned a little rendering problem I was having after the recent software upgrade. Scott Watermasysk of Telligent sent along a magic piece of CSS that resolved the issue -- he even put it on the site himself! Drop a comment if...
  • DWWTWT?: October 24

    It's days like today that try a walker's soul: a persistent, cold rain combined with an obligation to look decent for those attending our class. Taking my grandson to school in the car was an easy call, even before he gazed at me with those big, blue...