SQL Server 2016 Query Store - Gentle Introduction - 1

Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give a quick introduction to the sam...

Read More

Query Store – Part 2 - Configuration Settings

Introduction to Query Store covered here . Now for the second part on “How to Configure?” Query Store is configured at the database level...

Read More

Query Store - Part 3 - How it works?

Query Store collects 2 important kinds of data. They are 1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of ro...

Read More

SQL Server 2016 - “Number of Rows Read” on Execution plan

One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan. If you are wondering,...

Read More

Residual Predicate and Number of Rows Read in Execution Plans

What is Residual Predicate? Lets say one gets a query to fine tune. While checking the execution plan, if there is a Index seek, it is c...

Read More

SQL Server 2016 SP1 Release - Thoughts and Comments!!!

SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition have been made availab...

Read More

SQL Server 2016 - SQL Service Doesn't Start after GDR Security update

Recently, after an security fix GDR ( https://support.microsoft.com/en-us/kb/3194716 ) on  SQL Server 2016 RTM, SQL Service refused to star...

Read More

SQL Server 2016 SP1 – Rocking RELEASE!!!

Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation w...

Read More