if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102
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.
Device Is Not Ready: Fix Operating System Error 21
Device Is Not Ready is the Windows text behind operating system error 21, which SQL Server reports inside error 823. This post explains what the message means, lists the common causes, and gives read-only checks to run before any restart. It ends with the DBCC CHECKDB step that proves the database is healthy.
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.