-
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…
-
SQL DBA Cheatcode Part 4 : Few Important Queries for any DBA
Dear Readers, I am back with part 4 of Cheatcode series after gap of almost one month. In First three Parts of this series I covered, Few Generic Scripts, Replication Specific Scripts & Database Backup\Restore Specific Scripts. In this Series, I try to cover those Scripts which we can use in our day…
-
March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures
Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used to temporarily set specific server characteristics or to switch On/Off a particular behavior. Trace flags are frequently used to diagnose performance issues or to debug stored procedures.…