Oh, and he said the best way to find the IDENTITY of a row after inserting it would be to truncate the table before inserting it, so that the IDENTITY...

You must be joking, right?

I wouldn't compare Firebird to SQL Server, way too many differences between them.

I'm using both, and like both, but I would never use Firebird in place...

Yes, no progress without disagreement. 🙂

And I am sorry to keep you guys awake: I am in Australia trying to wake up. 🙂

I am curious then: how would you define a relational database if it is not one that tries to adhere to...

Codd and Date (http://en.wikipedia.org/wiki/Relational_model)....

Well, at least you admit it is an issue: SCHEMABINDING is a hack to make SQL Server conform a bit more to...

OK, so it is a documented bug. Documenting a bug and providing a workaround doesn't mean it...

Perhaps I've missed something but this is a bug in SQL Server, right?

Sad to see that Select-*-bashing has reached a point where genuine bugs aren't called bugs anymore if they...

I wish all experts were this honest! Thanks for the insights.

Alex

Uniqueness of the actual "prints" probably isn't even the main issue (with any biometrics). An imperfect or partial biometric "print" from a crime scene could "match" several originals regardless of...

But at least with DNA, because it is relatively immature, an attempt is made to quantify the error rates.

The possibility that more of us are (at least to some...

There are much more fundamental problems that are easily obscured by technical issues.

The entire principle of fingerprint evidence is scientifically flawed. In spite of what most people think they know,...

In my opinion whether derived tables and/or CTEs are "tables in any sense" is not really relevant. What is relevant is that they can, and probably should, be used in...

Thanks for the overview.

It would be good to mention CTEs as well. In my opinion they are very usefull and much more readable than derived tables.