Question: Why Execution Plan Operator Read More Rows Than Available?
Answer: Statistics.
Now let us learn detailed answer in this blog post.
What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254
Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
MemoryGrantInfo – What are Different Status of IsMemoryGrantFeedbackAdjusted? – Interview Question of the Week #253
Question: What are Different Status of IsMemoryGrantFeedbackAdjusted (MemoryGrantInfo Property)? Today we will see a consolidated answer to this question.
How to Disable Batch Mode in SQL Server? – Interview Question of the Week #252
My immediate reaction was why would you disable batch mode in SQL Server when it is really is an awesome feature for performance
How to Determine Read Intensive and Write Intensive Tables in SQL Server? – Interview Question of the Week #251
Question: How to Determine Read Intensive and Write Intensive Tables in SQL Server?
Answer: The script is very simple and lets us see in the blog.
How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250
Question: How to Write INNER JOIN Which is Actually CROSS JOIN?
Experienced this question another day while working with a client.
How to Use GOTO command in SQL Server? – Interview Question of the Week #249
Question: How to Use GOTO command in SQL Server?
Answer: Let us see a simple example of how GOTO works in SQL Server in this blog post.