Thanks Steve, I will try your suggestions and get back to you.

Thanks jonathan , more or less we are also adopting the same process.

As you said "I start with the rule of processing shared dimensions first, non-shared dimensions second and the...

alzdba,

I am not getting your comments in last mail.Pl. elaborate.where will i should see the execution plan in INSERT session or in SELECT session ?

Oops , My question is wrong - Pl. read the below one text 'now' is changed to 'not'

Alzdba, I dont have index on 'Code' field

Hi Gurus,

I am using default...

THanks a lot friends for the replies.

Actually its a daily load process , Activities we are performing are -

1. truncate all the from all 12 nos tables.

2. Drop all...

On the same instance another OLTP testing database is also running but its used in day time and ETL runs in night time.

Maint. plan is there to defrag indexes, also...

You are rignt, Autogrow is TRUE in my database, Its daily upload for more then 50 US locations of data. Should i take fairly maximum size of database and transaction...

Hi sqlSushi,

Thanks for the reply.

I am not getting your steps

Step1 DTS Files to master table

what are DTS files and what is master table here ?

Step2 DTS contents of table...

Actually i am storing xmls of 8k each in many of the fields of table , it is a read only table so no threat of INSERT/UPDATE and size increases.But...

Hi Experts,

It will be a great help if i also get the scripts mentioned in this topic. Following is my requirement -

CSV file to Sqlserver 2000 sp3a Loading

I...

Thanks Mr. Moor for such a vital info about JSharp.

I appreciate if i get comment on my strategy stated in last mail.

Sorry instead of sp_updatestats i will use -

UPDATE STATISTICS statement wiht FULLSCAN clause , specifies that all of the data in the table is scanned to gather statistics, thru...

Thanks for the replies. Actually i am planning to keep Auto create/update statistics ON (which is already there) .Apart from that I am planning to to run -

exec sp_updatestats

for...

Dan and Frenk ,Thanks for the replies.Can anybody know more about java.NET will it work with sql server 2000 ? Is there any other way to write sp like COM/vb...