Viewing 15 posts - 1,966 through 1,980 (of 3,061 total)
neliii (5/13/2010)
Select * from tablename
question is... why would somebody do "select *" on a 30 million rows table?
May 13, 2010 at 12:58 pm
Being using ERWin for over 15 years now - I think it is a fine tool.
May 13, 2010 at 12:56 pm
You missed the ultimate tool in your list - the human brain, being using it for data modeling purposes for over 25 years now, always worked fine. 😉
May 13, 2010 at 12:50 pm
Three clues...
1- Triggers are created in a table.
2- Trigger has to know when to fire - insert? delete? update?
3- If you want trigger to insert in another table, you have...
May 13, 2010 at 12:47 pm
Sooner or later Oracle support is going to ask to apply SP3 - save yourself some time and do it beforehand 🙂
May 13, 2010 at 12:43 pm
Oracle does not supports VARCHAR(5000)
The highest you can go is VARCHAR2(4000)
What's the data type and size of the Oracle side column?
What version of Oracle is it?
May 13, 2010 at 12:39 pm
hbujar (5/11/2010)
I have a question for oracle, is it possible to recover only partition from backup tape e.g Part_201005 if I delete from database.
In general this is not possible but...
May 11, 2010 at 1:03 pm
Irfan-358189 (5/11/2010)
... please also explain to me clustered and no-clusterd index and their difference
A non-clustered index is a object totally separated from the table. Index points to the table.
A clustered...
May 11, 2010 at 12:56 pm
bozworth hollinz (5/10/2010)
May 10, 2010 at 2:54 pm
creating custom functions and other stored procedure alike objects is the way to go.
May 10, 2010 at 2:48 pm
info-849042 (5/4/2010)
Hi, I need to form relationships from several-hundred tables to one table. Is there a quick way I can do this (SQL script, etc)?
Everything and anything can be done...
May 10, 2010 at 2:34 pm
Z@f (5/9/2010)
... will be question upon "Redundant Structures"
This expression applies to optimization structures in large environments like multitera byte data warehouse, such structures come in two flavors which are non-redundant...
May 10, 2010 at 2:29 pm
Sid Childers (5/9/2010)
I was able to get this one figured out last night. Thanks for your reply.
I'm glad but... still curious 🙂
May 10, 2010 at 9:37 am
Carl Federl (5/7/2010)
Don Peterson has written an article on why you should not use the type of design that you are proposing: "Lookup Table Madness" at http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/
I totally agree...
May 8, 2010 at 8:05 am
Sid Childers (5/8/2010)... I need to know whether I should reference my PKs and FKs in the stored procedure?
What do you mean with "reference my PKs and FKs in the...
May 8, 2010 at 7:53 am
Viewing 15 posts - 1,966 through 1,980 (of 3,061 total)