A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the old file based approach but it got me thinking what other options are out there and what are the pros and cons with them.
A con I would have to say with spatialware is the fact that it is $5000 p/a and only MapInfo can read the objects from it. Which at the moment is fine because MapInfo is all we use.
I'm wondering what other people have gone with and what their experiences are.