I got the opportunity to work on the area of SQL Server Performance Tuning have built a video course on the topic of Analyzing SQL Server Query Plans.
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
In this blog post, I will include a few resources which I promised during my presentations at Techorama Netherlands 2019.
Today we will talk about a sample long-running query which I use for my demonstrations. I travel across the world presenting on SQL Server.
Today we are going to see a very simple but brain teaser puzzle. This puzzle is about Deleting Qualified Rows From Multiple Tables.
SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.