Viewing 15 posts - 16 through 30 (of 32 total)
H!!
Could you please briefly explain what issues are you facing ??
September 1, 2005 at 2:59 am
H!!,
There are many ways by which you can transfer oracle user to SQL server.IF you intend to transfer only the tables constraints,index and data here is the best solution...
August 31, 2005 at 3:16 am
H!!,
I felt partitioning into filegroup as a better way to improve performance ,initially a new file group should be created for the production database and seperate the index into...
August 18, 2005 at 5:51 am
h!!,
Similar to SQL loader in oracle SQL server has DTS which can be used efficetively for transfering data across RDBMS with ease .Only disadvantage of DTS is it won't...
August 18, 2005 at 5:32 am
H!!,
Suppose if you are intending to add a column to a replicated table you can make use of this stored procedure
sp_repladdcolumn @source_object = 'authors'
, @column = 'newcol'
regrads,
vinod (DBA)
HTC...
August 12, 2005 at 1:05 am
H!! Anurag,
If you want to get the total advantage of reindexing then you have to opt for offline reindexing.Usally downtime'll be taken for reindexing process
regards,
vinod
August 11, 2005 at 1:13 am
H!!,
even my our junior DBA had similar type of error ..I had asked him to temoprarly Increased RAM and using sp_configure adjust memory used by SQL server considering the total...
August 10, 2005 at 2:32 am
please stop thi stupid discussions
August 9, 2005 at 6:38 am
H!!,
Please check weather any other process are running in the user of oracle from which you are trying to port the data..
vinod(DBA)
July 28, 2005 at 2:48 am
h!!,
register the remote SQL server on Enterprise Manager by adding a route to your server using IP address..
regards,
Vinod (DBA)
09840856202
July 19, 2005 at 6:19 am
H!!,
While migrating from Oracle to SQL server for you have to follow the steps.
1) take out the table creation script from oracle and change the syntax and datatypes accordingly...
July 13, 2005 at 3:00 am
H!!
Create composite non clustered index on the columns in which you try to execute the select statement ..
vinod (DBA)
HTC Global Services
July 12, 2005 at 1:42 am
H!!,
you can move tempdb to a diffrent drive with more space using the command listed below..
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME =
'D:\mssql\data\\tempdb.mdf')
go...
July 6, 2005 at 5:29 am
H!!,
I feel you are having an ERP system in the front end with more number of users..if you are very pirticular about decreasing the size of log file then you...
July 6, 2005 at 5:26 am
H!!,
The networlk protosols is disabled in your MSDE ,to resolve this secario you have to give DISABLE NETWORK PROTOCOL =0 which configuring desktop engine.
regards,
vinod (DBA)
HTC GLOBAL Services Inc
June 29, 2005 at 6:59 am
Viewing 15 posts - 16 through 30 (of 32 total)