Test why query cost percentages are estimates by comparing two statements with STATISTICS IO, TIME, and query DMV counters.
Comparing a Good and a Bad Plan for One Query in Query Store
Compare a good and a bad plan in Query Store using runtime history, SSMS Compare Showplan, estimates, joins, grants, and parallelism.
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
Finding Regressed Queries in Query Store After a Deployment
Find regressed queries in Query Store using weighted before-and-after duration and CPU, then compare plans and changed procedure text.
Granting Read Access to One Schema With GRANT SELECT ON SCHEMA
Use GRANT SELECT ON SCHEMA for focused read access, test a loginless user, and check ownership chains and table-level DENY behavior.
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.