News for hackers. Stuff that matters.
Re:MySQL 5.7: over 1M queries/sec on a single machine by corresation on Saturday November 23, 2013 @12:24PM (#6786635)
we need to serve 10k req/sec of a simple query, can SQL Server do that

Several years ago with SQL Server 2008 R2 I achieved 200,000+ simple queries per second (http://bit.ly/IlH2id -- this is not a regimented benchmark by any measure of the imagination, but is only saying "validate before assuming" because you might find your install performs far better than you anticipate) using the standard TDS query interface. This was on pretty beefy hardware, and is obviously enormously contingent on the data being in memory (which you can force with 2012), however it blew me away and completely undermined an initiative we had to implement AppFabric / Redis or other solutions.

Re:MySQL 5.7: over 1M queries/sec on a single machine by bsg75 on Saturday November 23, 2013 @01:27PM (#6786871)
> contingent on the data being in memory (which you can force with 2012)

What is the mechanism to do this in MSSQL 2012?

Re:MySQL 5.7: over 1M queries/sec on a single machine by jacabado on Saturday November 23, 2013 @03:45PM (#6787353)
I haven't seen it on the new features of 2012, but I have seen it on some demos of 2014 Beta: http://stevenormrod.com/2013/09/an-overview-of-sql-server-20...
Re:MySQL 5.7: over 1M queries/sec on a single machine by corresation on Saturday November 23, 2013 @05:22PM (#6787676)
Whoops, I meant to say 2014.
Re:MySQL 5.7: over 1M queries/sec on a single machine by bsg75 on Monday November 25, 2013 @10:18AM (#6794435)
I did not spot the mistake, simply assuming it was MSSQL version-after-2008.

Is Hekaton the feature you are referring to?