Well, there are n ways to monitor the performance.

The first choice would be the SQL Profiler.

Better go thru these articles which has worth of informations:

http://www.sqlservercentral.com/columnists/lPeysakhovich/performancetipspart1.asp

http://www.sqlservercentral.com/columnists/lPeysakhovich/performancetipspart2.asp

This should also help you :

http://support.microsoft.com/default.aspx?scid=kb;en-us;282463

http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp

This should also help you :

http://support.microsoft.com/default.aspx?scid=kb;en-us;282463

http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp

Thanks ..but I cannot spot the downloadable file either...

Also, the DTS from Wrox is not available in Bangalore :-(((

Dont forget..there's a cool offer from MS recently.

The second attempt is free for the exams you take.

Check in MS or Prometric sites..

Hey, Raj that was not the problem...

Just wanted to know from where did you pick these comments...

Is it in BOL ?? Would like to know the reference...its actually gud !!...

Help to read these article ...has worth of info.

http://support.microsoft.com/kb/224071/en-us

http://support.microsoft.com/?id=314546

http://vyaskn.tripod.com/moving_sql_server.htm

Boy, U shud be able to do it now 😉

Thanks Greg...that's the Wrox one that I shortlisted...

Will go for it..

Thanks all for the reply. I'm yet to dirt my hand on Sql'2005.

So, right now..the goal is all about '2000.

Thanks !

I just go for backup and restore instead of attach/detach options.

There is lot of about migration in the BOL and MSDN site...check that up.. all d best

If its deleted from the drive and you have valid/recent copy in the tape drive then you can restore it.

Dont worry ...not a problem :-).

Check the below links.

1. http://www.sql-server-performance.com/sql_server_maintenance.asp

2. http://www.aspfaq.com/show.asp?id=2471

If this doesn't help you ,check the BOL [Books online] and search for DBCC and...

Raj:

The below update was top notch. Thanks for it.

Where did you fetch this info ?? Would be nice to know !!!

"U can unhide it by this command

c:>attrin -r -a -s...

Well, practically having more no of either .mdf or .ndf will increase your performance. The indexing will be quicker and if the files are on shared disk array then the...

Folk, DTS is the best bet. Just take time to go through the below links. You will be able to do it easily. Just create a package and you are...