different collation on different databases

[holdahl]

I have 4 databases on my SQL server 2005.

2 of them have the same collation, but the 2 other have different ones.

Does a different collation have anything to say regarding performance or does it affect in any way?

should all databases have the same collation or is this normally not a problem?

any suggestions?

sH

 

[mrdenny]

A different collation will not effect performance unless you are doing a join or subquery across databases with different collations.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[holdahl]

are the collation set on the database when it's created?
should all new databases created be set to the same collation? or does it have anything to do with the content of the database? (I'm not quite sure which collation to choose when creating a new one...


sH

 

[Catadmin]

There is a default collation that is set when you install SQL. For SQL 2000, it defaults to Latinxxx which is good for most English/American installs. For SQL 2k5, it defaults to the collation of your OS.

Collations are useful when your servers are in different countries and require different character sets or when you need to use specific ANSI/UNICODE options. If you've never needed this, don't worry about collation. Just use the default.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"