What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?
Do MAX Function Scan Table? – Interview Question of the Week #289
Question: Do MAX Function Scan Table to retrieve the data?
Answer: Yes, if there are no indexes to help retrieve data. Let us learn it today.
SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)
The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)
Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
Patch Your SQL Server – SQL in Sixty Seconds #100
When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
List All Parallel Queries – SQL in Sixty Seconds #098
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.
Keyword Join or Inner Join – SQL in Sixty Seconds #099
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different?
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.