Delayed durability offers something that many SQL Server professionals have wanted for years-the ability to disable transaction logging. Why turn off the transaction log? You can accelerate ...

If the transaction log and database are in the same device you can't do a transaction log dump. In this case you need do a Truncate Log on Checkpoint. You also can't dump the log if the Select ...

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

Database management provider SingleStore announced today it has added a Universal Storage capability to simultaneously support transaction applications that store data in rows and analytics ...

I would like to know how transaction log size is managed. I now know after some reading that I can checkpoint the database in order to allow dirty pages to write from ram to disk.I also know now ...

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

Microsoft has RTM'd SQL Server 2014, which includes a new in-memory OLTP engine built jointly by Microsoft Research and the SQL Server team.

In summary, we've looked at how organizations can leverage the security and high-performance strengths of their existing high-transaction systems while ensuring that they can make these systems ...