Viewing 15 posts - 286 through 300 (of 3,061 total)
Lynn Pettis (5/2/2012)
Question. We know that TRUNCATE TABLE in SQL Server can be rolled back if inside a transaction. How about in Oracle?
Can't rollback TRUNCATE in the Oracle...
May 3, 2012 at 2:26 pm
rossss (5/2/2012)
Can be? It is always faster. See my previous post for details.
I'm just quoting the official Oracle documentation, see the link.
It is always faster 😀
May 2, 2012 at 3:10 pm
durai nagarajan (5/1/2012)
As...
May 2, 2012 at 5:17 am
rossss (5/2/2012)
Removing rows with the TRUNCATE statement can be faster than removing all rows with the DELETE statement...
Can be? It is always faster. See my previous post for details.
May 2, 2012 at 4:59 am
Perfect!
Only the dbcc command may take longer on production, elapsed time is going to be a function of how much data is already sitting on the offending datafile.
May 1, 2012 at 3:04 pm
aurato (5/1/2012)
PaulB-TheOneAndOnly (5/1/2012)
aurato (5/1/2012)
May 1, 2012 at 1:43 pm
durai nagarajan (5/1/2012)
PaulB-TheOneAndOnly (5/1/2012)
durai nagarajan (4/30/2012)
i to want to create partition as the data in some tables are more that 50 Lakhs.
May I ask what are you trying to accomplish...
May 1, 2012 at 12:30 pm
aurato (5/1/2012)
May 1, 2012 at 12:25 pm
Triality (5/1/2012)
Is it possible to create "pass-through queries" using the Query Designer or is it only possible when you actually write the T-SQL in SQL view?
You do it on Query...
May 1, 2012 at 11:44 am
mohan.bndr (5/1/2012)
I want to know that what are the per-requisites for Database Up gradations?
Firstly, you have to know why you want to upgrade; are there new features? functionalities? company policy?...
May 1, 2012 at 11:14 am
Triality (5/1/2012)
This actually helps quite a...
May 1, 2012 at 11:02 am
Triality (5/1/2012)
May 1, 2012 at 10:37 am
If the Oracle materialized views are fully refreshed once a day I would probably go with snapshot replication as opposed to transactional replication.
May 1, 2012 at 9:02 am
durai nagarajan (4/30/2012)
i to want to create partition as the data in some tables are more that 50 Lakhs.
May I ask what are you trying to accomplish by partitioning the...
May 1, 2012 at 7:00 am
tajinder42 (4/30/2012)
April 30, 2012 at 10:27 am
Viewing 15 posts - 286 through 300 (of 3,061 total)