Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2009-04-28 : 08:01:28
|
| Hi allJust a question i have thought about recently, when installing and you get to the collation setting should you select Binary check box i read somewhere on MSDN that Binary or Case was the preferred method. Did i read this correctly? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-28 : 09:52:22
|
| A binary or case sensitive collation will give you a performance boost of a couple % depending on the kinds of queries you are getting., but will make you very careful in other ways. Generally, I would only use a binary or case sensitive sort order on databases that are taking literally thousands of queries per second and the majority of those are based on character field comparisons. |
 |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-04-28 : 18:03:19
|
| Thanks for the response i suppose i am still confused however when you say the kind of queries you are getting, could you give me an example of a character field comparison?So in your opinion you would not select these options for a standard install then?Much appreciated. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-29 : 10:17:21
|
| [code]select (fields)from tablewhere name = 'stumbling'[/code] |
|
|
|
|
|
|
Collation