The SQL Server Performance Tuning Recorded Class will be available for the next 4 days at a rate of 40% discount. Act Now – Only 50 Seats!
Analyzing SQL Server Query Plans – Pluralsight Online Video Course
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.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
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.