Tag Archives : SQL Server 2014

---

SQL Server 2014 – Buffer Pool Extension

This entry was posted in Features and tagged SQL Server SQL Server 2014 on January 20, 2014 by Colleen M. Morrow

In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to hold every last byte of data we would need to store. We wouldn’t worry about disk latency, and PAGEIOLATCH waits would be nothing more than a distant memory. But you and I, we live in the real […]

---

SQL Server 2014 – Delayed Durability

This entry was posted in Features and tagged SQL Server SQL Server 2014 on January 13, 2014 by Colleen M. Morrow

Pop quiz: What does ACID stand for? That should be a pretty easy question for database professionals: Atomicity Consistency Isolation Durability It’s that last property, durability, that I want to talk about today. Durability guarantees that, when a transaction is committed, it stays committed. The changes made by that transaction are permanent, even in the […]

---