Thanks for the links. Just one question, our database is currently in English. So the reason we switched to Unicode was to accept other languages. So is there one collation...

We took our 2005 database and scripted it to create scripts to use Unicode, nvarchar, etc. So we have our unicode database created, just need to know the actual database...

Hey guys,

Sorry for the delay. The server has a Tomcat webserver on it and hosting only one application, very min. resources. I checked disk space, there 400GB still free. Now...

wow guys........thanks for all the input.

I certainly know where to begin now with this project. I'm going to start next week on this. Should be smooth sailing....now....i hope now anyway...haha

thanks...

did u have to change every data type? or is there an easier way to do this?

Thanks for responding. We do have connection pooling enabled in our web application at the request of a client. Is that a best practice?

Yeah I think I'll have to discuss...

One more question associated with this. If you look at the properties of the database theres an option to "AutoShrink", whats the best practice for this?

Thanks,

oh ok. I'll take your advice. I think the developer has some bugs in the code causing the slowdown. He introduced STRUTS into the java app, so I'm thinking there...

Thanks for the reply. The reason I brought this up was the application seemed little slower, wasn't sure if this was the cause. Either way I'll do a shrink on...