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)

Browse by Tags

Related Posts
  • Blog Post: Database Programming: Sunday Night Prime Number Update

    Our blogging site is going to go dark in an hour or so for a software upgrade, so I won't be able to post my full findings tonight. What I can say is that, based on the current "rules of engagement" (i.e., the timer starts when the tables are populated), I believe I've got the execution time of the...
  • Blog Post: 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 ( new SQL MVP , by the way!) Like... just populate...
  • Blog Post: Database Programming: A Prime Number Contender From Down Under

    Denis' Prime Number Challenge just won't die. I think this topic has spurred more dialog than any other in this blog's 15-month, 180-odd post history. Just imagine if I could've harnessed this global outpouring of SQL skills for something with commercial potential.. J Rob Farley has two posts on his...
  • Blog Post: 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 having here. Since I've already finished the...
  • Blog Post: Database Programming: Denis' Prime Number Challenge: Fourth Place Finisher

    Hugo Kornelis posted a wonderful reply on his blog to the Prime Number Challenge, which runs in 9.3 seconds on my laptop. Denis posted his solution in a reply on Hugo's blog ; Denis' solution runs in 6 seconds . WOW! Perhaps this isn't such a crazy undertaking after all. I've been working on my...
  • Blog Post: Database Programming: Denis' Prime Number Challenge

    ' Denis the SQL Menace ' read Wednesday night's post on "the million GUID march" and offered up a challenge of his own: How about the next challenge is to return all 78498 prime numbers between 1 and 1000000? What an interesting idea! Crazy, in a sense (I'll get to that in a second), like most...
  • Blog Post: Database Programming: Closing The Door On The "Discredited" Prime Number Tangent

    This post will close the loop on the "discredited" prime number syntax tangent, the code for which was first posted here and subsequently modified here (and briefly referenced here ). When we last left this discussion, I'd abandoned this approach as a contender for first place in Denis' Prime Number...
  • Blog Post: 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 wrote an article about how to return prime numbers...
  • Blog Post: Database Programming: Denis' Prime Number Challenge: A New Leader

    Well, folks, there's a new sheriff in town.. this is a continuation of a conversation here and here . I've tweaked Hugo's syntax to further filter the initial seive population (similar to the pre-filtering present in the discredited tangent ). Where's Hugo's syntax took 8 seconds on my laptop and...
  • Blog Post: More From Dad's Bookshelf

    Frequent readers of this space will recall that I'm in western Vermont visiting with family until the end of the coming week. This morning, I'm in a small country store about a mile and a half from Dad's place, and I'm using their wireless network to reacquaint my laptop with the Internet. Last time...