Re: Sybase vs SQL Sevrer really?
Are you talking about a comparison between SQL Server when it was released in 1994 with the 1994 Sybase or something recent? Must be the 1994 version you last compared.
"I much prefer ASE for its performance and ease of use" where is the ease of use with Sybase, I am losing you here. It doesn't even have a proper SQL Development env I am using something that was hacked together by Sybase. Compare this to tools you get with SQL Server. Unless you prefer using the command prompt and you find this easier.
Why don't you put your money where your mouth is if you feel so confident with Sybase, £300 bet for the winner. I challenge you to beat SQL Server with any bit of SQL you want (has to be reasonably complex) not a join between 2 tables!. We run on same machine, same indexes, same data, I guess you want Linux, I use sql server 2008. You provide the SQL (or have plenty SQL anyway), we need few tables with some million rows each. You devise the SQL tests, but needs to be complex sql.
Contact me at sqlsybase at gmx.com if you would like to win £300.
As of Hana, this is not a proper relational database and have never seen it on a Sybase install. Should I mention tabular then on sql server then? SQL server has in-memory since 2012. Check the 2 billion rows it can query in 1 second white paper. But lets keep this simple RDBMS vs RDBMS (ACID compliant) systems only.
For the people who say Linux or windows or whatever, the Database is a fast as the optimiser is. Awaiting your email...