nathan.mcdonald wrote:This I have heard is not right and can cause speed issues later.
The only setting we recommend altering from default is to use mixed mode authentication. By default I think it's Windows Authentication only.
I certainly know for a fact that messing with the default collation and sort orders is going to cause you problems - these should be left alone.
The rest of the settings you should not have to alter.
EDIT : However, we are always open to suggestions from anyone who has other ideas! Please, do let us know your thoughts on this.