What are the optimal settings for setting up a SQL Server 2008 Spatial database with full UK OS MasterMap data in?
- Seperate tables for the different feature types, or a single table with everything in it?
- What spatial index settings have you found work best?
Any "best practice" or experience gained would be appreciated.
For reference, I'm using Cadcorp to display the data.