Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
It seems my blog post about oStress has got lots of popularity. Recently I got the question about Wait Statistics Generated by oStress Insert Workload.
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?