Viewing 15 posts - 2,866 through 2,880 (of 3,061 total)
GilaMonster (10/11/2008)
PaulB (10/11/2008)
you know for a fact uniqueness is enforced on the source dataset
I wish all the source data that I had to work with was as clean...
October 11, 2008 at 10:32 am
I love you too guys but not every table need to have a PK.
How about staging tables in a Data Warehouse environment?
As you should know Staging tables are nothing but...
October 11, 2008 at 2:56 am
If you are running on SS2K5 you are going to get always "DISABLED" on your query. That's by design.
We keep track of licensing in an Excel document.
Additional info here... http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
October 10, 2008 at 4:51 am
Answering your questions.
1- Yes. There are differences in the way SQL Server 2005 stores data.
Perhaps the most notorious one is the way SQL Server 2005 overcomes the old 8K limitation...
October 10, 2008 at 2:31 am
is there any questions?
October 9, 2008 at 10:27 am
Bottom line is... you do not migrate queries in between Transact-SQL and Oracle's SQL*Plus, SQL or PL/SQL; you translate them meaning you read the source query, understand what it does...
October 4, 2008 at 5:19 am
the plot thickens!... there is not such a thing as Bug #6646512 documented on Oracle's Metalink, interesting.
Glad it working now.
October 2, 2008 at 9:03 am
steveb (10/1/2008)
shakti (10/1/2008)
I know how to create the triggers? but is it a suggested procedure? i feel that if the...
October 1, 2008 at 12:39 pm
shakti (10/1/2008)
October 1, 2008 at 8:27 am
You may want to check this... http://articles.techrepublic.com.com/5100-10878_11-1054237.html
October 1, 2008 at 6:52 am
douglasr (9/17/2008)
I have a high consumption of tempdb.
This is not a problem, this is just a sympthom showing how your code works. Look at the code.
October 1, 2008 at 6:49 am
I see.
Not sure how critical is the issue for you but better to get the Oracle Service Request upgraded to either sev=1 or sev=2 - in my experience...
September 30, 2008 at 1:40 am
I'm really sorry but I do not understand your question.
Anyway...
1- Your commit statement is Okay.
2- Your update statement is updating all rows in the table.
3- I would use merge statement...
September 29, 2008 at 7:08 am
Ask your Oracle contact to run the offending query in a session altered as follows...
alter session set events '10046 trace name context forever, level 12'
... then tkprof the trace file...
September 29, 2008 at 5:31 am
Viewing 15 posts - 2,866 through 2,880 (of 3,061 total)