This is the third part of the series Incremental Statistics. Here is the index of the complete series.
What are Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
SQL SERVER – Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
This is the second part of the series Incremental Statistics. Here is the index of the complete series.
SQL SERVER – What is Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
This is the first part of the series Incremental Statistics. Here is the index of the complete series. Let us learn it together in the blog.
SQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
I have been reading this Whitepaper from a couple of days and I am yet not done reading it completely, but I think it is one of the best white papers I have read in the recent time. First of all, it is written by my friend and SQL Expert…
Read MoreSQL SERVER – Wrap on Series of Temporary Statistics
This is the final post in the series of the Temporary Statistics. I have previously written about this subject in a few posts. I have received quite a few questions about this series so I decided to include all the questions in this one blog post. Before you read this…
Read MoreSQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent
This is a follow up blog post to my earlier blog posts about statistics for Read-Only Database. Please read the following blog post in this series to get further idea about this subject: SQL SERVER – Statistics for Read-Only Database are in TempDB SQL SERVER – How to Script Statistics…
Read MoreSQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only
Earlier last week I wrote a blog post about Statistics for Read-Only Database are in TempDB, I received a very interesting comment from Ayman El-Ghazali on the same blog post. Let me reproduce the same comment over here. “Nice post. What if you create a database, create some statistics in…
Read More


