I wanna get ahead of the long process of ordering a database for V3, but I’m not finding anything regarding requirements for the server in the docs. specs is easily changed, but collation can be a pain as I understand.
The specs don’t matter too much and we aren’t taking advantage of any fancy SQL features so you should be able to us any supported MS SQL version. SQL express has a 2 GB limit so you will need to take than in to consideration but may be good for testing. If you groom more aggressively (especially with job data), you can comfortably fit in 2 GB.
As for collation, we use the default SQL_Latin1_General_CP1_CI_AS collation. The big thing here is that it doesn’t do character expansion on strings so sorting and comparison work as expected.
SELECT * FROM MyTable3 WHERE Comments COLLATE SQL_Latin1_General_CP1_CI_AS = 'strasse' SELECT * FROM MyTable3 WHERE Comments COLLATE SQL_Latin1_General_CP1_CI_AS = 'straße'
Rather than with something like Latin1_General_CI_AS which does character expansion rather than using string literals.
SELECT * FROM MyTable3 WHERE Comments COLLATE Latin1_General_CI_AS = 'strasse' SELECT * FROM MyTable3 WHERE Comments COLLATE Latin1_General_CI_AS = 'straße'
We specify this for the database during creation so it won’t inherit it from the server settings.
I’ll make sure this info gets into the docs.
@adam will ther ever be a need for running SQL Agent Jobs?
My SQL guys is trying to determine if my databse should be placed on an existing cluster where we will not get access to “the agent”, or if we should get a seperate isolated server.
I can’t envision a need for this. In reality, the database is pretty simple.