H!!,

     I feel you had missed out some steps in between ,follow these steps to configure linked server sucessfully

1) Product name :  Oracle

2) Datasource    :  SID of Oracle database...

h!!!!,

    In your queries and other SQL statements, always represent date in yyyy/mm/dd format. This format will always be interpreted correctly, no matter what the efault date format on the...

h!!!,

     Keeping tempdb in memory was an option of SQL server 7.0 which was eliminated in SQL server 2000.In production environment if you pin tables in cache also there won't...

h!!!,

   Checkpointing a database can be done mannualy by the command sp_configure 'recovery interval' 5

reconfigure with override

the above configuration will checkpoint the database at 5 min like this you...

H!!!,

   If updates and deletes are more in your database obiously tlog will grow to a very large size .

as a solution for this you can backup transaction log every...

H!!!,

                      This is a composite primary key which is created for a combination of seven columns ,in this scenarion the combination of seven columns ie PEOPLE_CODE_ID,ACADEMIC_YEAR

ACADEMIC_TERM,ACADEMIC_SESSION,PROGRAM,DEGREE and CURRICULUM of a...

H!!!,

       You had mentioned that the size of your database is 75 Gb ,so you have to first find out the number of records in each table & do reindexing...

H!!! , cpu moving towards 100%  usage can happen in multiuser envirinment due to improperly maintaned databases .

1) you have to check weather the frequently accessed query'a are indexed properly...

H!!!,

 This is vinod DBA , Plz run the SQLDIAG utility which is inside BINN folder & check for the error's inside LOG folder of SQL Server installation ,moreover you can...

H!!!,

 Yes we have done complete migration form SQL server 2000 to postgres by porting data from six diffrent databses to Postgres due to licencing issue for one of our client(app...

H!!,

   Mr.Killer had suggested the most appropriate solution ..but you should be very comfortable in taking the right decission to recover the database in case of a failure ..

Regards,

Vinod (DBA)

+91...

H!!!,

            what's the size of your datafile?? IF it's more that 20gb u can think of logshipping by using Enterprise Edition of SQL Server 2000 but if the size of...

H!!,

   Can you check the logical  fragmentation of you database by DBCC SHOWCONTIG ?? If index pages are fragmented you can go for a DBCC DBREINDEX for frequently accessed tables...

H!!,,

    Could u revert which isolation level are you using with your stored procedures ??

Vinod DBA

HTC GLOBAL SERVICES

H!! Toad ,

          In clustered index while inserting new record it will be put in order ..moreover if the page is full

the page splitting will occour and approx half...