Viewing 15 posts - 61 through 75 (of 229 total)
Can you let me know what the purpose of the WHERE clause is in the destination table?
Couple of more suggestions:
1. In your Oracle ODBC DSN, disable LOBs if you're not...
February 16, 2009 at 9:53 am
Hi Stewart
I'm not really an expert but I don't recall having to specify a where clause in the openquery destination. Perhaps it is this that is causing the row level...
February 16, 2009 at 8:36 am
Jeff Moden (2/14/2009)
Roy Ernest (2/13/2009)
Bruce W Cassidy (2/12/2009)
Roy Ernest (2/11/2009)
February 14, 2009 at 4:30 pm
Bruce W Cassidy (2/8/2009)
February 9, 2009 at 1:29 pm
GilaMonster is absolutely correct, performance needs to be tweaked and the proper analysis on the query execution must be done first - hints are always a last resort. Non sql...
February 6, 2009 at 4:08 am
Well, not all devs are cast in the same forge but if they are and they've got lots of money, I've eseen reports that the 0.5tb goes for btw $275k...
February 6, 2009 at 3:13 am
Do you have WITH RECOMPILE at the top of the proc?
Edit: Sorry, didn't register that you're using adhoc sql generated in the app. If that is the case perhaps consider...
February 5, 2009 at 5:28 pm
The theory is good, but for me the most defining feature of a relational database would be the ability to enforce referential integrity, excellent reading though.
February 5, 2009 at 5:15 pm
Ich wuerden mit Deutsch zufreiden sein, but I think there are some native German speakers here anyway.
February 5, 2009 at 5:09 pm
Gift Peddie (2/5/2009)
You starting in it does not make it relational starting with the data types, aggregate functions and DRI trigger wizard which is actually invalid in...
February 5, 2009 at 2:22 pm
ALZDBA, further to SSD's...
There's a white paper here from Texas Memory Sysems if you're keen: http://txmemsys.com/AD-SQLsP-Txt.php. Register and then scroll to the bottom of the page (would attach the pdf...
February 5, 2009 at 9:17 am
Gift Peddie (1/18/2009)
...Access and VFP are things Microsoft sells as database both are not relational.
Heh? Access is relational.
As would seem apparent by other people's posts, I also started off with...
February 5, 2009 at 7:01 am
Jeff Moden (2/4/2009)
Doc (2/4/2009)
Hi all,I just want to contribute with a couple of pictures I've found on the net 😀
Man, I hope that's a light sabre he has in his...
February 5, 2009 at 3:58 am
Generally I'd agree and I even remember agreeing with my lecturer and colleagues, however, I just checked the matrix report I was referring to and I sucessfully display the data...
February 4, 2009 at 11:03 am
Looking back, I think that the columns are displayed in the order they are returned. Please note that the column order behaviour may reflect that of a character data type.
February 4, 2009 at 5:29 am
Viewing 15 posts - 61 through 75 (of 229 total)