Viewing 15 posts - 1,861 through 1,875 (of 3,061 total)
Jeff Moden (6/11/2010)Excellent point, Paul. I never understood why Oracle chose to separate "SQL" from "PL/SQL".
That's a very good question which puzzled me for a long time.
Even when I...
June 13, 2010 at 6:24 pm
I bet returned error was something like... Incorrect syntax near the keyword 'end'. (Source: MSSQLServer, Error number: 156) ... isn't it?
Next time please copy/paste full error message so to...
June 13, 2010 at 5:39 pm
BSKR (6/12/2010)
can anyone givewhat is data model and how to design and implement
process of designing a database and capacity planing
May I ask what is your background?
June 13, 2010 at 4:16 pm
David Portas (6/13/2010)
In principle all keys are equal.
I have to disagree here. Call me old-school but I do differentiate in between natural keys (the ones that have a meaning) and...
June 13, 2010 at 2:32 pm
robblot (6/11/2010)
I have been talking to different programmers about the primary field of my tables.
Please do not take it the wrong way but you shouldn't be talking to programmers about...
June 13, 2010 at 10:55 am
Good tips Jeff.
Also - if working on a data warehouse environment forget about: bitmap indexes, materialized views, star-transformation and query rewrite. SQL Server offers a much simpler yet solid platform.
By...
June 11, 2010 at 2:51 pm
sgalbra (6/11/2010)
June 11, 2010 at 11:57 am
Appears to me this is a text book ODS table scenario - a table that will sit there until some day in the future an ETL process starts sourcing from...
June 11, 2010 at 11:08 am
Nice job. You manage to figure it out what 10046-trace was supposed to do.
Just out of curiosity, how did you figure it out without looking at the bind variable on...
June 11, 2010 at 10:50 am
Not sure if I got exactly what the issue is but it looks like the process intends to tell if some product "run" or not in a specific period of...
June 11, 2010 at 8:44 am
I run two scripts...
1st one drops all privileges coming from Production
2nd one creates privileges we want to grant in Test
June 11, 2010 at 8:25 am
cfry-1152891 (6/11/2010)What is the best practice for keeping the data up-to-date easily?
Are Development and Test Production size databases?
Test should be Production size to allow for real testing while - depending...
June 11, 2010 at 7:57 am
Fantastic feedback - people will benefit of it for a long time. Great job! 🙂
June 10, 2010 at 7:41 pm
Viewing 15 posts - 1,861 through 1,875 (of 3,061 total)