Viewing 15 posts - 2,101 through 2,115 (of 3,061 total)
chandrasekaran.ganapathy (4/8/2010)Here What is the use of creating Index?
Allow me to answer you with a question... What is the use of having an index in a book? perhaps...
April 8, 2010 at 12:35 pm
Lynn Pettis (4/7/2010)Not completely true
Not completely exact.
As you know during a truncate operation SQL Server logs page deallocation information - that's why you can roll it back. This is...
April 8, 2010 at 11:59 am
Simon AV (4/8/2010)What would be the best editiion of SQL2008 to use for this ? Standard, Enterprise or Web ? Not sure where to go with this one !
I would...
April 8, 2010 at 6:43 am
GSquared (4/7/2010)SQL Server, as with any tool, has limitations.
Have you noticed how vendors usually call them "features" 😛
April 7, 2010 at 1:48 pm
Gift Peddie (4/7/2010)
April 7, 2010 at 10:21 am
phanish81 (4/7/2010)
April 7, 2010 at 10:11 am
Too many issues/questions in a single post, lets go to the basics.
Lets use a HHRR datamart as an example. In a star-schema like the one you describe you have a...
April 7, 2010 at 7:51 am
miss.delinda (4/7/2010)
4. What is the difference between DELETE & TRUNCATE commands?
Too many questions for a single post - I'll take #4 for $400 😀
DELETE - assuming no predicate in the...
April 7, 2010 at 7:27 am
I'm in agreement; I would be tempted to take the poor thing out of its missery and redesign it on the 3NF.
Having said that #1... how about the application? better...
April 7, 2010 at 7:21 am
Gosta Munktell (4/7/2010)
From that table you can check if rows already exists in the "main" table and avoid to import them/Gosta
ahhh... you check against target table, that's cheating Gosta! :-D...
April 7, 2010 at 6:22 am
sumit.joshij (4/6/2010)
At least they(ORACLE corp) can have the knowledge...
April 7, 2010 at 6:08 am
DNA_DBA (4/7/2010)
I would think it is some data conversion issue. For example, Oracle dates have a much larger range than the SQL Server datetime datatype can handle.
I agree that...
April 7, 2010 at 5:44 am
born2bongo (3/15/2010)
I can't see what is wrong with my code.
Since you didn't post the code we cannot either 😀
April 7, 2010 at 5:41 am
born2bongo (3/15/2010)the reasons are not clear.
Either application got a stack of ORA-nnnnn errors or Oracle wrote a stack of ORA-nnnnn errors into Oracle's side alertlog.
Ask your Oracle DBA to check...
April 7, 2010 at 5:37 am
Viewing 15 posts - 2,101 through 2,115 (of 3,061 total)