Category: SQL Server

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 […]

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 […]

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 […]

In my last post we looked at how to set up the system to use OPENROWSET to read Excel Worksheets from SQL Server. I believe that using the OPENROWSET function is the most flexible and practical method for linking Excel worksheets to SQL Server. Before we look at OPENROWSET, however, let’s take a moment to review […]

Julia P. from the Learning Tree Transact-SQL Programming course writes “I’ve tried to use the OPENROWSET function to query Excel files, but I keep getting the same error. No matter what I try, SQL Server responds with “OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)” returned message “Could not find installable ISAM.”.” Hi, Julia. Unfortunately,lots […]