DBCC command list

DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)…

Read More

Using DBCC SHOW_STATISTICS

This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:

Views –…

Read More