Regina Obe has developed a table to compare the new SQL Server 2008 with PostgreSQL/PostGIS (with MySQL thrown in there to boot). The table does a wonderful job showing the comparative strengths and weaknesses of all three relational databases.