Because you are having slash (/) in between of your text. That's why it's ignoring /Defence part. Just use "ACE/Defence ....... " then it will insert whole of your text

You can create same database name in sql2005 and use sp_attach to upload dataabase file and log file for the same

Your table need to get repaired. If possible then recreate your table. or just run checkDB or dbcc checktable option with repair

Even in this case creating a Non Cluster index on date (ASC or DESC) will help a lot. As you mentioned that you probably required one day to fetch the...

You have not speciifed that you were loading data from another database or some files.

This error comes once you have EOF mark or End Of Line mark before or...

Certainly partitioning table will help you in this regard but don;t forget to partition your indexes too.

You just check with your benchmark (accepted) values. Ideally it is based on the concurrency, Database sizes and h/w efficiency.