• Paul Randal (6/18/2014)


    Not unless you say WITH TABLOCK.

    Hmmm......one last question....all my data files are sitting on same drive....i know DBCC very high intensive.....i was thinking to let DBCC run in serial fashion not to cause any IO contention ( which might take longer)....would DBCC run faster if i have it executing against all the database in parallel Vs serial?