Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Hekaton Rss

   Items 1 to 9 of 9   

SQL Server Internals: In-Memory OLTP

In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.  Read more...
By Kalen Delaney 2014/11/11 | Source: | Category: books
Rating: |  Discuss |   Briefcase | 596 reads

Compare SQL Server Performance of In-Memory vs Disk Tables

With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?  Read more...
By Additional Articles 2014/10/10 | Source: | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 8,302 reads

Dynamic Management Views: Changes in SQL Server 2014

SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?  Read more...
By Edward Pollack 2014/07/08 | Source: | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 4,010 reads


By Steve Jones 2013/12/06 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,857 reads

Myths and Misconceptions about Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!) Over the...  Read more...
By Klaus Aschenbrenner 2013/12/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,572 reads

Overview of the Different In-Memory OLTP Index Types

In-Memory table or what Microsoft refers to as In-Memory OLTP, or Hekaton is a new type of table is available with SQL Server 2014. In this article Greg Larsen discusses the different types of indexes you can place on your In-Memory tables, and how those indexes support different search criteria.  Read more...
By Additional Articles 2013/11/13 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,277 reads

Project Hekaton

Today Steve Jones talks about the Hekaton features that are coming in SQL Server 2014.   Read more...
By Steve Jones 2013/11/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads

Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton

In order to take full advantage of the In-Memory OLTP options in SQL Server 2014, you should migrate standard stored procedures that references Memory-Optimized tables to natively compiled ones. In this tip we will see how to achieve this goal.  Read more...
By Additional Articles 2013/10/25 | Source: | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 2,866 reads


By free mascot 2013/10/04 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 2,339 reads
   Items 1 to 9 of 9   
sql server 2014 (5)    
in-memory oltp (3)    
blogs (1)    
books (1)    
dmv (1)    
dynamic management view (1)    
editorial (1)    
indexing (1)    
memory optimized tables (1)    
monitoring (1)    
oltp (1)