Assert Archives - SQLServerGeeks

SQL Server execution plan – Simplifying : Part 11

January 31, 2014September 10, 2014 - by Kanchan Bhattacharyya - 2 Comments.

Hi Friends, While checking SQL Server execution plans over last few weeks on this series; you would have seen these terms quite frequently; Actual Rebinds / Estimated Rebinds Actual Rewind/ Estimated …

SQL Server Execution Plan – Simplifying : Part 9

January 23, 2014September 10, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, In my previous blog post, Part 8 of this series we analyzed SQL Server execution plan using INSERT statement. Today, we will try UPDATE statement followed by explanations. Let us …

SQL Server Execution Plan – Simplifying : Part 8

January 18, 2014September 10, 2014 - by Kanchan Bhattacharyya

Dear Friends, SQL Server engine generates SQL Server execution plan for all SQL queries in order to figure out best path of execution when we submit any request. In my previous …