Cost of unicode?

I've converted most SQL Server databases to unicode since the AS 400 stores data in unicode (UTF-16). So far the only difference I see is that running queries to text in Unicode takes a lot longer, and UTF-16 files are 4x as large as Cp1252 files.

Any way to get the file sizes / query times of old with Unicode?Try Transact SQL forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1), you are more likely to find SQL perf experts there. This forum is specific to SSIS.

Anyway, UTF-16 files should be two times larger than CP 1252 files (not sure how you get 4x larger files). There is nothing that can be done with it other than switch to different encoding, e.g. UTF-8 which is another Unicode encoding and might be more compact if your files mostly contain latin characters.|||Thanks for the suggestion... I've created a new thread here.