Denis

As I said on this forum, I'm also a fan of surrogate keys.

Actually, my goal in this first article is to show the concepts and methods I'm using to compare...

I understand this is article deals with an important subject on database design and it is natural to see some strong positions and different ideas.

I'd like to thank everyone...

Dan

I got the point. This first article shows a simple example to illustrate the use of the approach I describe, but my goal is to analyze the use of a...

Hugo

I respectfully disagree.

Yes, no question all alternate keys should be implemented as unique indexes.

But once no unique key is implemented at all, (but only the primary key in each...

tom,

I agree.... I heard many times that the best advantage of surrogate keys is the performance improvement and this is not always true, as I intended to show in the...

Michael

I totally agree with your comments on the FKs and the need to add these remarks on the conclusion of this article.

I'll make sure to comment about FKs when I...

admin

I had 2 options here: either I used different SQL statements based on the primary key of each table (surrogate or natural key) or used one single SQL statement based...

great idea. thanks for taking the time to share it with us

Nice article!

People tend to avoid time tables relying on SQL functions. This is a good approach if you don't need to do those calculations frequently.

I remember a project where...

Hi David

I understand your point.

But it came out so naturally to me writing statements with aliases that it never crossed my mind to say they are optional.

But I should have...

Hi, super, thanks for your comments ... (and thanks everybody for all other comments on this articles).

I feel it's rather risky to try to find a golden rule when it...

Extending a bit more on Jeff's comments, this is true not only for ORACLE (PL-SQL), but also for DB2 (SQL PL).

Like ORACLE, DB2 obligates you to use cursors in situations...

Well, I understand the fuzz, although I didn't mean to create it.

When I wrote this article I had in mind that not all T-SQL beginner are completely unaware of database...

In fact, concatenating strings will not do on this example.

This works when you have one scalar value to return, instead of a whole table.

But there are workarounds, of course.

I don't...