Success !! (well, I'm about 99% sure I have found success, I still have some further testing to do, on 'real' data)

Amazing what a weekend away from a problem can...

Version 2. getting warmer.

I now have a handle on how the code in the other article works.

So I made a few changes to the test data, and tried again.

/*

-- create...

I'm not going to judge the merits of the problem. But I am going to point out a small but important thing that I see crop up frequently:

'[' +...

Of course if you operate in more than one country (or...

David Portas (11/5/2010)

---

I highly recommend you avoid using rhetoric like "twelfth normal form". It might be (mis)interpreted as a lack of respect for data integrity and sound design practices. Data...

I don't understand why any discussion about surrogate vs natural keys always degenerates into an idealogical 'flame-war'. At least this particular thread has remained fairly tame.

So a further 2c...

What we're...

My 2c on the general arguments of 'surrogate' vs. 'natural' keys.

a quick resume:

I have formal (university) training in database design, and I understand relational and normalisation theory.

I'm (currently) a small-time...

Hugo Kornelis (10/25/2010)

---

Let's suppose you and I both build a database for airport services. The business expects the SSN (for US citizens; for non-citizens, their countries' equilvant of the SSN...

No, and it doesn't really make sense - TOP implies 'importance' i.e. TOP...

Not that I want to encourage bad habits, but I seem to recall a discussion (I thought it was here @ SQL Server Central, but I can't find it) regarding...

Jeff Moden (9/28/2009)

---

Heh... I see 3 recommendations to build a Calendar table and two that claim they've used one, yet no one has offered up any of their own code...

probably slightly off topic, but this reminds me of a job I did some years ago where the client was only interested in years and weeks - a fresh produce...

For me, I've never used Enterprise Manager on a machine once I've installed the full SSMS from SQL 2005 or SQL 2008; SSMS has everything I've ever needed from Enterprise...

I really don't have a strong opinion on how to store IP addresses, since I've yet to be asked to do so for any of my clients (thankfully).

But nonetheless I...

Thanks for that.

Don't know why I never thought of this before, coming from a VMS background, where clustering systems is an (almost) trivial task that we took for granted because,...