Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Monday, December 21, 2015 11:52 PM
Points: 245, Visits: 750
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 @ 6:05 PM
Points: 34,254, Visits: 18,425
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