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.
SQL SERVER – 7 Resources From Techorama Netherlands 2019
In this blog post, I will include a few resources which I promised during my presentations at Techorama Netherlands 2019.
MySQL Preferred Engine – MyISAM or InnoDB
Most of my time is spent with my clients on the Comprehensive Database Performance Health Check. MySQL Preferred Engine – MyISAM or InnoDB
SQL SERVER – Sample Long-Running Query for Demonstrations
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.
Puzzle – DELETE Qualified Rows From Multiple Tables – Win USD 1000 Worth Class
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 – Using Memory-optimized Tables and Native Stored Procedures – Video Course
SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.
What is Faster, SUM or COUNT? – Interview Question of the Week #231
Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.