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
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: Today @ 1:28 AM
Points: 245, Visits: 748
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



Group: Administrators
Last Login: Today @ 10:03 PM
Points: 32,684, Visits: 16,978
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