Matt-1034261 (8/31/2010)

---

Ramji29 (8/31/2010)

---

Thx Gail for...

Thx Gail for correction... I...

Matt... size of...

Yeah there was one more thought on this....

it will be better if the data selected (from other table or tables for inserting into my table) shud be ordered in the...

seems to more of a classroom based question.... refer below links.

http://www.sqlusa.com/articles2005/top10/

http://articles.techrepublic.com.com/5100-10878_11-5823776.html

http://www.microsoft.com/sqlserver/2005/en/us/features.aspx

http://searchsqlserver.techtarget.com/tip/Top-10-new-features-in-SQL-Server-2005

Rohit

Depends to your edition as well but most of 2005 editions supports max amount of RAM that OS supports.

refer http://msdn.microsoft.com/en-us/library/ms143506%28v=SQL.90%29.aspx

Rohit

You can also try for any third party data recovery tool.....

Thanks a lot Bhuvenesh & Gila for youe suggestions & comments....

Bhuvnesh (8/20/2010)

---

Rohit few things .....

First,

Ramji29 (8/20/2010)

---

I asked them to update the parent first and then insert into child (Although...

GilaMonster (8/20/2010)

---

This is a SQL Server forum, not a MySQL forum. I'd bet that most people here have minimal experience with MySQL. I suggest that you try asking this on...

USE ALTER INDEX command with drop_existing and specify the new file group.... You can write a dynamic query and loop ot for all the clustered indexes if you just want...

Check if below helps.

http://msdn.microsoft.com/en-us/library/Aa366720

Go with what Bhuvanesh suggested... but just take a backup of msdb before doing anything.... and what abt the last backup of msdb... do you've it??

Yes you need to run checkd on msdb db. But make sure you've a valid backup beforehand.

Have you tried with giving this account local admin rights to this...

its more like whatever...