Forum Replies Created

Viewing 15 posts - 16 through 30 (of 32 total)

  • RE: SQL Server expert in South Australia

    H!!

     

    Could you please briefly explain what issues are you facing ??

  • RE: Import Oracle DMP to MSSQL Server 2000

    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...

  • RE: looking for partitioning design and strategy

    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...

  • RE: Flat Files

    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...

  • RE: Temporarily disable replication

    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...

  • RE: reindexing problem SQL2K - General network error

    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

  • RE: reindexing problem SQL2K - General network error

    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...

  • RE: Getting CREATE TABLE script with constraints!!

    please stop thi stupid discussions

  • RE: Importing error- Oracle table to SQL Server 2000

    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)

  • RE: How to access database on FTP site

    h!!,

     register the remote SQL server on Enterprise Manager by adding a route to your server using IP address..

    regards,

    Vinod (DBA)

    09840856202

  • RE: Porting entire Oracle9i schemas to SqlServer 2000 or 2005

    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...

  • RE: Slow Query

    H!!

      Create composite non clustered index on the columns in which you try to execute the select statement ..

    vinod (DBA)

    HTC Global Services

     

  • RE: No space inTemp DB

     

    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...

  • RE: T-Log growth

    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...

  • RE: MSDE???

    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

     

Viewing 15 posts - 16 through 30 (of 32 total)