Viewing 15 posts - 61 through 75 (of 75 total)
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...
September 14, 2009 at 4:05 am
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...
September 14, 2009 at 3:35 am
It seems we might agree to (mildly) disagree on the more subjective points raised.
Yes, no progress without disagreement. 🙂
September 13, 2009 at 9:41 pm
And I am sorry to keep you guys awake: I am in Australia trying to wake up. 🙂
September 13, 2009 at 8:50 pm
I don't define a modern relational database that way, no.
I am curious then: how would you define a relational database if it is not one that tries to adhere to...
September 13, 2009 at 8:48 pm
I said that in my first post. Not sure why you think it is a hack though, or to which relational model you refer.
Codd and Date (http://en.wikipedia.org/wiki/Relational_model)....
September 13, 2009 at 7:18 pm
SCHEMABINDING was brought in to help address this issue
Well, at least you admit it is an issue: SCHEMABINDING is a hack to make SQL Server conform a bit more to...
September 13, 2009 at 6:50 pm
Paul White (9/13/2009)It is clearly documented behaviour.SCHEMABINDING is the way to avoid it.See sp_refreshsqlmodule.Paul
Paul White (9/13/2009)
SCHEMABINDING is the way to avoid it.
OK, so it is a documented bug. Documenting a bug and providing a workaround doesn't mean it...
September 13, 2009 at 6:32 pm
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...
September 13, 2009 at 12:55 am
I don't like to predict the future, as I am usually wrong.
I wish all experts were this honest! Thanks for the insights.
April 10, 2009 at 6:13 pm
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...
November 12, 2008 at 3:50 pm
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...
November 11, 2008 at 4:35 am
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,...
November 10, 2008 at 7:29 pm
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...
April 2, 2008 at 6:07 pm
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.
April 1, 2008 at 9:50 pm