Thank you for your thoughts. I hope you can help me further on this as to be more precise...

I have a situation where a column in a table has been...

There is absolutely no fix rule as how often the db should be reindexed - all depends on what is the volume of inserts/updates taking place on a daily basis....

The BOL reading was most interesting.

This could be a stupid question. What is/are the argument(s) for a CASE-INSENSITIVE or CASE-SENSITIVE option?

I would appreciate if someone could kindly explain please.

Noeld,

Many thanks for pointing me to the right direction.

Regards

Herbie

Been there before. There are times when reinstalling SQL server is possibly the best option if there are not too many database already attached to it. Fiddling around with rebuidling...

Hi

Try using WinRAR - an excellent tool which I have personally used a lot on database close to 10 Gb.

http://www.rarlab.com/