Tag: dbcc errorlog

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2)

by

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2016. 1. DBCC errorlog This DBCC command can be used to truncate the current SQL Server log. You can use this command when you rarely...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented Maintenance SQL Server 2014 DBCC Commands

by

Undocumented Maintenance SQL Server 2014 DBCC Commands In this article, you can find the description of some useful undocumented maintenance DBCC commands, and find out how you can use these commands in SQL Server 2014 for administering and maintenance tasks. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →