Tag Archives: sql 2014 new features

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