Linux Virtual Memory: Do We Still Need a Swap Area?
Some urban legends are created and maintained because they tell a story with satisfying irony or surprise. It’s some form of “It implies such a pleasing story that it ought to be true.” For example, the claim that Western European and American railway gauge is derived from a long series of standards going back to […]
SQL Server 2014 New Features: How to Create a Hekaton In-Memory-Optimized Table
Practice: How to Create a Hekaton Memory-Optimized Table In this installment, we will step through the actual process of creating an in-memory table for an SQL Server database. As mentioned in the Hekaton overview, in-memory tables are streamed into RAM when SQL Server starts up. We must therefore first create a special FILESTREAM filegroup for […]
SQL Server 2014 New Features: Hekaton In-Memory Optimization & the Theory of Hash Indexes
Theory: What are Hash Indexes In contrast with conventional disk-based tables, in memory tables possess neither row IDs nor clustering keys to help SQL Server find a row. In-memory tables are therefore required to have at least one index. In this installment we shall look at the details of the hash index. As we shall […]
SQL Server 2014 New Features: Hekaton In-Memory Optimization
What a Hekaton In-Memory-Optimized Table Is and Is Not By now, most SQL Server jocks and jockesses have heard that the “heka” in “hekaton” is the Greek word for 100 and refers to the potential, if perhaps elusive, 100-fold performance improvement using Hekaton in-memory tables for transaction processing in SQL Server 2014. Whether intended or […]