> > Have you speed-tested FB2 vs. MS SQL Server 2005 Express Edition. I
> > would be
> > interested in knowing how these two free databases compare.
>
> I have not done any benchmarking of SQL Server X, partly because it
> is the same code base.
>
> We evaluated SQL Server X for our embedded engine rejected it because:
>
> - The database size has been crippled to 2G
> - The installer requires .NET (and installs it).
> - The footprint is 50G

How much?

> Not to be totally negative, I should list the advantages:
>
> - Mature, well understood
> - Able to store databases in a single file
> - Full set of built in functions with correct NULL handling (unlike
> FB...)

Examples of failures in Fb? I'm just curious.

> - Sophisticated collation support (better than FB)

Different, that's for sure.

> - Great performance (better than FB)
> - My office mate use to be on the SQL Server dev team ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com