As Nadrek said create indexes on last step is correct way.

He gave good suggestion.

Thanks

Irfan

I think we have some misunderstanding.

Can you please make it clear that for example there are two tables abc and xyz and they have joins.

here i am not clear...

table abc...

No,It will slow down the update process if you will put indexes before update.

If tables are small then ok otherwise always try to drop the indexes if you are going...

Follow these steps please.

The process Drops indexes.

Truncates table.

Populates table.

updates table

populates it with MORE data.

Finally Adds indexes.

Mean you should create/build indexes in the last step.

Thanks

Irfan

Thank you 🙂

I did,t pay attention in the commented areas in the bottom but before reading your reply i read and came to know how to stop=0/delete=2/restart=1 the race.

Thank you very much...

Ok,The above code will give me the last executed batch/command not the current running right?

and how to stop this trace because in profiler i know if you create any i...

Thank you sir but i am not good in T-SQL/declaring variables.I would like to have some thing short like one SP which i can run and get required information or...

I have tried and it get created like windowid.dbo.tablename 🙂

It does,t matter from the day 1st or day end If you have any proactive monitoring scripts to schedule please let me know otherwise thank very much for you time.

I am upgrading SQL2000 to SQL 2005 ans SQL 2008,I will say you can say SQL 2000 and SQL 2005 for now.

right? Yes rebuild task mean Alter Index Rebuild and Reorg.

DBCC DBREINDEX is for rebuild index and DBCC INDEXDEFRAG is for reorg.

.ndf and .mdf both are data file,the difference is...

Mark,Thank you very much for answeres.May be i dont have clear concept about filegroup so please can you tell me is it possible to add filegroup while database is live?and...

Ravi,Just for information,Do you know why these files were missing or why i need to copy them there?

I did upgrade in the same server few weeks before and i did,t...

Ravi,You cant believe me how stressed i was and i dont have words to say you THANK YOU VERY VERY MUCH.

It works now.