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 10 of 10   
 

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/05/13 | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 7,427 reads

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: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 782 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: MSSQLTips.com | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 8,326 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: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 4,086 reads

Hekaton

By Steve Jones 2013/12/06 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,862 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,652 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,297 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 288 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: MSSQLTips.com | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 2,886 reads

Hekaton

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