Is SQL Server "keeping up" with MySQL?
I read a comment in a Connect suggestion today that implied that implementing their suggestion would allow SQL Server to "keep up with MySql." Regardless of the actual suggestion, that made me laugh out loud… and since I was on the train, that got me some weird looks.
The actual suggestion was to add row constructors, e.g.
INSERT dbo.Table (col1, col2) VALUES (1, 2), (3, 4), (5, 6), (7, 8);
Of course, SQL Server 2008 adds support for this construct. Better late than never. However, my impression is that this is the exception rather than the rule. When did MySQL finally add stored procedures? How about transaction support, SSIS-like capabilities, a scheduled job management system, and a relatively easy-to-use consolidated GUI management tool?
"LIMIT" notwithstanding, if SQL Server's functional specs weren't already light years beyond MySQL with SQL Server 2005, it will certainly leave them in the dust when SQL Server 2008 hits the streets.
Now, this isn't a slam on MySQL really, but rather I am questioning the narrow perception of many MySQL users. I am curious if you can provide a list of features (aside from "LIMIT") that MySQL has that SQL Server doesn't, or that MySQL had first. Perhaps my perception is the one that is narrow.