By Lori Brown | Miscellaneous , SQL Administration , SQL Server
Available in SQL Server 2014 – All Editions Delayed Durabilty is a way to defer the acknowledgement of the transaction log records getting written to disk, i.e. transactions can continue without waiting, and SQL will assume that the log record *will* be written. You may know the ACID rules (Atomicity, Consistency, Isolation, Durability) that guarantee […]
Continue readingBy Lori Brown | SQL Administration , SQL Server
Available in SQL Server 2014 Enterprise Edition In-Memory OLTP is a new lock-free, latch-free, optimistic concurrency approach to storing data in memory. While it may seem reminiscent of DBCC PINTABLE is it definitely not the same since data in memory-optimized tables is not organized in pages, and does not use the Buffer Pool. It is […]
Continue readingBy Ginger Daniel | Performance Tuning , SQL Administration , SQL Server , Windows
Recently, a client of mine contacted me in a panic because almost all of the memory on the SQL server was used up…according to Task Manager, that is. Don’t panic…task manager is probably lying. Well, a little bit anyway. And Task Manager is just that, a task manager. If you are looking at it to […]
Continue readingBy Lori Brown | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
Recently I had to do some R&D for a project and needed to generate a large table to test performance on. Since it is important to test queries on large data sets I thought that I would post how I populated a few data types in my table. To test query results I decided that […]
Continue reading