One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES.
SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103
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.
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.Â
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.
Alter Index Add Column – Workaround – SQL in Sixty Seconds #097
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.