Tag Archives: sql2014

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