Category Archives: sql2014

Interesting facts about SQL Server 2014 Memory optimized tables and Natively compiled stored procedures

  Stored Procedures that reference only memory-optimized tables can be natively compiled into machine code for additional performance improvements Only one MEMORY_OPTIMIZED_DATA Filegroup can be created on each database In Memory OLTL is Lock and Latch Free In-Memory OLTP is … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , | Leave a comment

Buffer Pool Extension – New feature in SQL Server 2014

Before diving into Buffer Pool Extension (BPE) details, it is worth taking a look at the Buffer Management to refresh your knowledge. You may find buffer management details @ http://technet.microsoft.com/en-us/library/aa337525(v=sql.105).aspx Buffer Pool Extension (BPE) can use nonvolatile storage devices (Ex: … Continue reading

Posted in SQL, SQL Query, sql2014 | Tagged , , , | Leave a comment

Incremental statistics – New feature in SQL Server 2014

Incremental Statistics is one of the new feature added in SQL Server 2014, let us have a quick look to understand this feature! Statistics is one of the important criteria to be validated during performance analysis as improper statistics directly … Continue reading

Posted in SQL, SQL Query, sql2014 | Tagged , , | Leave a comment

Knowledge Share 2014-04

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment

SQL 2014 New Feature – Natively Compiled Stored Procedure

How is it different from normal Stored Procedure? A natively compiled stored procedure is compiled when it is created, rather than when it is executed. That compile process first translates the store procedure code into “C”, and then into machine … Continue reading

Posted in SQL, sql2014 | Tagged , , , , , | Leave a comment