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

Articles with tag OLTP Rss

Search for any content tagged oltp

   Items 1 to 8 of 8   
 

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2014/07/02 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 9,191 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2014/07/02 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 9,191 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2014/07/02 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 9,191 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,934 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,374 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,773 reads

Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimized 'Hekaton' technology, but how you balance between disk tables and in-memory tables for optimum performance requires judgement and experiment.  Read more...
By Additional Articles 2013/07/08 | Source: SimpleTalk | Category: sql server 2014
Rating:  Rate this |   Briefcase | 3,211 reads

A Reporting System Architecture

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...
Rating: |  Discuss |   Briefcase | 12,743 reads
   Items 1 to 8 of 8