Viewing 15 posts - 2,746 through 2,760 (of 3,061 total)
Jonathan Kehayias (2/3/2009)
PaulB elludes to this but doesn't actually make the point clear.
:w00t: mmhhh... I wasn't avoiding -elluding?- the issue and I think my proposed solution is spot on;...
February 3, 2009 at 9:52 am
tempdb utilization is a function of the application, in your case application was developed in a way where it does heavy use of features that end up hitting tempdb.
Question for...
February 3, 2009 at 9:04 am
Assuming you have a clustered index there - PK perhaps? - just reorganize such an index, table reorganizaton would happen as a subproduct of it. 😉
February 3, 2009 at 8:33 am
Adi Cohn (2/3/2009)
You can use create table for attach
Do you mean create database for attach?
sp_attach_db is deprecated
February 3, 2009 at 1:13 am
The old way would be by using sp_attach_db system storedproc but this is not the preferred method on 2005
You may want to...
1- alter database set offline
2- Issue one alter database...
February 3, 2009 at 1:11 am
This is happening on the SQL Server side.
You have to define a Linked server pointing to your target Oracle database.
February 3, 2009 at 1:01 am
Vichka (2/2/2009)
or is there another way exist? to copy the data from SQL 2000 to Oracle:hehe:
I had the opportunity of migrating from SQL Server to Oracle several times.
In regards to...
February 3, 2009 at 12:59 am
Hari (2/3/2009)
how can you attach more than 20 ldf files in sql server
One at a time?
February 3, 2009 at 12:52 am
You code should look like...
BEGIN DISTRIBUTED TRAN
Do your Oracle stuff
Do any commitable SQL stuff -even if your business specs do not ask for it.
COMMIT...
February 2, 2009 at 4:20 am
Ignacio A. Salom Rangel (2/1/2009)
Thanks for the query!
:w00t: What?!... not following; could you please elaborate 😀
February 1, 2009 at 8:50 am
I would get a letter from the vendor telling they are Okay with creating views, then go ahead.
You can word your request in the form "we are planning to create...
January 31, 2009 at 6:28 am
sys.master_files describes datafiles, not databases.
January 31, 2009 at 2:20 am
You are talking about learning database design; this is refreshing and believe me when I say I like your approach -too many people are already doing stuff they have no...
January 31, 2009 at 1:18 am
birgit.schelloeh (1/29/2009)
January 30, 2009 at 9:35 am
In my understanding you do not have a reporting database. A reporting database means you are taking a snapshot of production to separate "production" from "reporting" workload.
If I understood...
January 30, 2009 at 3:52 am
Viewing 15 posts - 2,746 through 2,760 (of 3,061 total)