Microsoft SQL Server DBCC DBCC informational statements

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Insert
> Step 2: And Like the video. BONUS: You can also share it!

Example

DBCC commands can show information about database objects.

DBCC PROCCACHE

Displays information in a table format about the procedure cache.

DBCC OUTPUTBUFFER ( session_id [ , request_id ])  

Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and optional request_id).

DBCC INPUTBUFFER ( session_id [ , request_id ])  

Displays the last statement sent from a client to an instance of Microsoft SQL Server.

DBCC SHOW_STATISTICS ( table_or_indexed_view_name , column_statistic_or_index_name)


Got any Microsoft SQL Server Question?