MySQL vs MS SQL Server - Which is better?

Question

If you have a windows server and unlimited money. Would you go for MySQL or Microsoft SQL Server?

Answer 1

Microsoft SQL Server because of:

Windows Authentication,

Indexed Views,

Query Analyzer for optimizing complex queries,

Clustered indexes,

Integration Services,

Reporting services,

Analysis services.

SQL Server Agent Jobs,

Profiler...

Answer 2

If money isn't an object, I'd lean towards SQL Server - besides the basic database engine, you also get better peripheral tools such as Integration Services, Reporting Services, Job Agent, etc.

Answer 3

mysql. The standard across the Internet is mysql, so anything you develop on it will work on any server. MSsql only runs on Windows servers. Since 80 % of web servers are NOT MS, this limits your use of MSsql. It is also not particularly fast or efficient.

Answer 4

depends on what Server Side language you're using, for ASP.NET id go with sqlserver since there has been a bunch of GUI tools integrated into it. For PHP or JAVA however id recommend MySQL since it's easier to configure and works better with these languages.

Answer 5

MySQL works better with more web servers.