if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
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?
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.
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?
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.
What is the fastest way to retrieve rowcount for a table? Whenever I am helping my clients with their SQL Server, I get this question.