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 I…

## 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 from SQL…

## 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 books I brought with me (Robert…

## 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…

## 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 on the topic (as well…

## 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 Challenge because the approaches Denis and Hugo used,…

## 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…

## 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 Denis’ took 6 seconds, this version takes under 3…

## 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 previous syntax…

## 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 interesting ideas,…