-
DBCC PAGE Command to Analyze SQL Server Database Objects
One of the most underrated commands, one can find in SQL is DBCC PAGE command. We are saying this not because, the command is not worthy enough to be used, but because it is an undocumented internal command of SQL Server. You will not be able to find much info about this command in online…
-
March towards SQL Server : Day 29 – SQL DBA Interview Questions Answers – All About DBCC & DMVs
Dear readers, Now its time to cover one of the most important topic for any Database Administrator out there. We owe our career as DBA to these small yet most powerful feature provided by Microsoft to check every minute details about our system and these little keywords always come to rescue when anyone from…
-
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning
Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is something that can’t be covered end to end – you know that. Let me try starting from basic concepts to some scenarios type question. What is the use…