Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out.
if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
Question: How to Kill Processes Idle for X Hours?