Pro Members, SQL Server, Standard Members

Some tips for using DBCC commands in SQL Server 2017

Some tips for using DBCC commands in SQL Server 2017 Use the DBCC SHOW_STATISTICS command to displays the current distribution statistics for the specified target on the specified table. You can use this DBCC command to see how distributed the data is and whether the index is really a good candidate or not. Avoid using the DBCC SHOWCONTIG command. This…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register

Comments are closed.