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

Content with tag in-memory oltp Rss

   Items 1 to 8 of 8   
 

SQL Server 2014 In-Memory OLTP Dynamic Management Views

Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.  Read more...
By Additional Articles 2014/04/16 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,108 reads

In-Memory OLTP - SQL Server 2014

By Ford Fairlane 2014/03/10 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,473 reads

Natively Compiled Stored Procedures with SQL Server 2014

With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.  Read more...
By Additional Articles 2014/02/12 | Source: Database Journal | Category: oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,840 reads

SQL Server 2014 In-Memory OLTP Architecture and Data Storage

Microsoft is releasing SQL Server 2014 with a new set of In-Memory OLTP features to significantly improve the OLTP performance and reduce the processing time for servers with a large amount of memory and multi-core processors. Check out this tip to learn more.  Read more...
By Additional Articles 2014/01/02 | Source: MSSQLTips.com | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,239 reads

How to Use Microsoft's AMR Tool

In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility. Greg Larsen explores how to use this tool.  Read more...
By Additional Articles 2013/12/18 | Source: Database Journal | Category: amr
Rating: (not yet rated)  Rate this |   Briefcase | 2,220 reads

Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables

SQL Server 2014 offers In-Memory OLTP, but you may be hesitant to use this because of the lack of support for constraints on Memory-Optimized Tables. In this tip we will see how we can solve these issues.  Read more...
By Additional Articles 2013/11/29 | Source: MSSQLTips.com | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 3,317 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,122 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,721 reads
   Items 1 to 8 of 8   
 
Tags
oltp (3)    
hekaton (2)    
sql server 2014 (2)    
amr (1)    
architecture (1)    
dynamic management views (1)    
index (1)    
memory optimized tables (1)