Exploring SQL Server File I/O with Xperf

Xperf is designed for hardcore Windows programmers and systems analysts, but it can also be an invaluable tool for SQL Server developers and admins who need to find very detailed answers as a part of some performance evaluation. However, Xperf is also great fun for those SQL Server folks who just want to throw up […]
Read More ›

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 […]
Read More ›

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 […]
Read More ›

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 […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.