It has less than a gig of RAM for SQL Server to run with.<br><br>So I can only assume that when I go to execute my query the server won't have all the data I need just sitting in cache (and that's ...

According to Jim Tommaney, CTO of InfiniDB, one of the key takeaways from the benchmark is that InfiniDB was able to handle the widest range of analytic queries – with large performance improvements.

Not bad. We used to be impressed with a thousand transactions per minute. But hang on, that Microsoft result was published a couple weeks after SQL Server 2005 was released. That’s a long time ago.

LCK_M* —This wait type happens when a query locks an object while another query is waiting to lock the same object. A common scenario is when a query is trying to modify a row while another query is ...