Viewing 15 posts - 106 through 120 (of 207 total)
GilaMonster (8/14/2009)
ta.bu.shi.da.yu (8/14/2009)
One point I would like to make though, is that it's definitely a special type of join where the left and right tables are the same table. Therefore...
August 14, 2009 at 4:04 am
michael vessey (8/14/2009)
I posed a question on our technical tests for new DBA/Developers and I asked
"Name All Types of join you are aware of"
The question was...
August 14, 2009 at 3:51 am
That's odd... this logged me in under a different account. Ah well.
August 14, 2009 at 2:15 am
Jeff Moden (8/13/2009)
ta.bu.shi.da.yu (8/13/2009)
Jeff Moden (8/13/2009)
jswong05 (8/13/2009)
True portability is a myth.
True, basic compatibility is expected. Nothing is 100% compatible to another thing.:-P Why don't database vendors got together and...
August 13, 2009 at 7:03 pm
Jeff Moden (8/13/2009)
jswong05 (8/13/2009)
True portability is a myth.
True, basic compatibility is expected. Nothing is 100% compatible to another thing.:-P Why don't database vendors got together and make one ANSI...
August 13, 2009 at 3:59 pm
Hmmmm... Paul, what does the following do?
GO 8
August 13, 2009 at 4:22 am
Grant Fritchey (8/10/2009)
August 11, 2009 at 8:02 am
Correct. If you don't need to get any responses from things like update statements, then best to turn this off - this reduces traffic to and from the server. Helps...
August 11, 2009 at 7:53 am
GilaMonster (8/10/2009)
ta.bu.shi.da.yu (8/10/2009)
August 10, 2009 at 7:22 am
oli (8/10/2009)
ta.bu.shi.da.yu (8/10/2009)
Strange as it may seem, if you run the Oracle Automatic Workload Repository ADDM report then you'll often get Oracle warning not to use the operator. It...
August 10, 2009 at 6:49 am
GilaMonster (8/10/2009)
ta.bu.shi.da.yu (8/10/2009)
But both of these are anti-semi-joins, which means that I don't actually think you need the top 1.What TOP 1?
Oops. Read something that wasn't there. Sorry Gail.
August 10, 2009 at 6:47 am
ronmoses (8/10/2009)
10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE...
August 10, 2009 at 6:46 am
Jeff Moden (8/10/2009)
GilaMonster (8/10/2009)
Sorry, but I'm going to greatly disagree with a number of these 'tips'
I have to agree with that. Gail's eval of some of the other tips...
August 10, 2009 at 6:38 am
vetri (8/10/2009)
I tried with these two statements but the second one is not get executing and it says "Incorrect syntax near the keyword 'exists'." What wrong with...
August 10, 2009 at 6:33 am
Viewing 15 posts - 106 through 120 (of 207 total)