Viewing 15 posts - 676 through 690 (of 824 total)
Yes and no. I am not a physicist and can't speak on the realative merits of Newton's and Lobachevsky's theories, so I won't attempt to. But you are correct when...
February 7, 2005 at 8:31 am
I agree that the mind should not be locked, but I also maintain that it shouldn't be unguarded either. A totally open mind is like a trash can, you never...
February 4, 2005 at 4:20 pm
Just a quick correction... The article stated "These values are stored as extended properties. The user can add as many extended properties as they like. They are stored in a...
February 4, 2005 at 1:38 pm
I'm sorry but you are confused. Codd's 12 rules are not about normalization, rather they define the characteristics of a Relational Database Management System. There are between 5 and 8...
February 3, 2005 at 5:02 pm
My best guess is that by moving the text into a varchar you increased the number of data pages in your table considerably. This may have caused pretty extensive fragmentation,...
February 1, 2005 at 3:55 pm
Basically whenever you see and ObjID of 0 it indicates an object for which there is no concept in sysobjects. Thus, databases, indexes, pages, extents, etc... will always have an...
February 1, 2005 at 3:45 pm
Are you shrinking the size of the log as part of your maintenance? This could cause a situation where the backup APPEARS to be larger than the file itself, but...
February 1, 2005 at 3:23 pm
This might help... http://support.microsoft.com/kb/304692/EN-US/
February 1, 2005 at 3:16 pm
It sounds like you need to setup a Linked Server. Once you define your Access db as a linked server you can query and update it pretty much as though...
February 1, 2005 at 3:08 pm
I should have also included the on-line Oracle documentation... I realize that Oracle Press is not exactly the same thing as official Oracle documentation, however there is an implied authority...
January 31, 2005 at 4:16 pm
Certainly the Sybex OCP Study Guides for 8i had no reference to the performance implications of cursors. I know, because I searched through them... I also grabbed every Oracle reference book...
January 31, 2005 at 2:32 pm
Unlike Oracle?!?!?! The idea that Oracle runs perfectly fine with cursors is a complete fiction! What is true is that Oracle (the company) doesn't make as big a deal of...
January 31, 2005 at 9:46 am
Nick,
As much as I agree with your general point that integrity should be enforced at the data layer, not the application etc... I think you shot yourself in the foot...
January 17, 2005 at 8:48 am
The best way of dealing with duplicates is to avoid them in the first place! Design your databases right and you don't have to worry about it. There is no...
December 20, 2004 at 4:11 pm
Not really, SQL Server already has Indexed views which are the same thing as Oracle's materilaized views.
December 2, 2004 at 11:33 am
Viewing 15 posts - 676 through 690 (of 824 total)