I have tried that also and i dont have that special character appearing.

It seems like you have an extra character at the end of you script or something (e.g. space)

Vivek

thanks guys. 🙂

Also, you can do it with red gate's multiple script, i've found out.

Vivek

We run index maintenance(rebuild/reorganise) every night on our sharepoint databases as our databases are highly used.

I don't see any harm in rebuilding/reorganising sharepoint indexes.

Vivek

Thanks for your reply danie.

I have managed to resolve this issue.

Index tuning wizard was unable to parase a query because some of the field in that table had special characters...

Thanks a lot for your help.

Vivek

Hi George

Would it be better to have 8k for tempdb files...

Should this make significant perf improvement?

Vivek

I am sure you can change this parameter in sql idera too.

by default it collects query information every 5000 milliseconds but it is chanchable using configuration wizard.

Vivek

we all are to the certain extent 🙂

Also, have a look at best practices for partition alignment. Server 2008 has special need.

http://msdn.microsoft.com/en-us/library/dd758814.aspx

I would really appreciate any thoughts or ideas guys on this one.

I would really appreciate any thoughts or ideas guys on this one.

also, have a look at the following. Its quite comprehensive.

http://www.sqlservercentral.com/articles/Upgrade/65872/

Good luck!

Vivek

yap.

http://www.microsoft.com/downloadS/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

I'd recommend following;

1. Perform side-by-side upgrade.

2. run upgrade advisor.

3. DTS is depricated feature so you have an option to upgrade it to SSIS or download compatibility pack from microsoft to...