SQL SERVER – DBCC commands List – documented and undocumented | Journey to SQL Authority with Pinal Dave

Database Consistency Checker (DBCC) commands can gives valuable insight into what's going on inside SQL Server system. DBCC commands have powerful documented functions and many undocumented capabilities. Current DBCC commands are most useful for performance and troubleshooting exercises. To learn about all the DBCC commands run following script in query analyzer. DBCC TRACEON(2520) DBCC HELP… Continue Reading...

Source: SQL SERVER – DBCC commands List – documented and undocumented | Journey to SQL Authority with Pinal Dave