Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Effect of collation change on tempdb space consumption Expand / Collapse
Author
Message
Posted Monday, January 17, 2011 6:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 6:22 AM
Points: 231, Visits: 721
If the collation for one database is different from all other databases on a SQL 2008 Server, will it impact the tempdb space consumption?

I understand that queries and joins may fail due to the collation difference and it could be handled using COLLATE database_default option.

Question is will collation difference anyway increase the amount of tempdb space consumption during joins / SORT/aggregate operations?
Post #1048724
Posted Monday, January 17, 2011 8:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
The worst case is that it could require more space due to a collation that forces everything to a Unicode comparison based on the data types, but it should not be a tremendous amount of difference. If you are making comparisons between Unicode-Unicode values, you'll need the same space.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1048778
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse