During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.
SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE
There are so many options you should experiment before you opt for query hint. Recently DBA asked me how to use query hint ENABLE_PARALLEL_PLAN_PREFERENCE.
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
How to Use a CASE Statement in the WHERE Clause? – Interview Question of the Week #239
Question: How to Use a CASE statement in the WHERE Clause? Answer: First of all – CASE is not a statement but rather an expression.
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check
SQL SERVER – PRINT Statement and Format of Date Datatype
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
SQL SERVER – 3 Different Ways to Explore Actual Execution Plans
We will explore 3 different ways to explore Actual Execution Plans. I had discussed this Comprehensive Database Performance Health Check.