Tony Stack

Tony Stack

  • 1.4k
  • 271
  • 101.1k

Prevent running DBCC SHOW_STATISTICS

Dec 13 2019 6:53 AM
I have recevied an issue which is, frequent hit for following query in SQL Server. But this line of code not used in our application
  1. DBCC SHOW_STATISTICS(N'"Demo"."dbo"."tblSettings"',"_WA_Sys_0000000C_125F7E8B"WITH HISTOGRAM_STEPS  
I need to know
1. Why this line of code executed 
2. Can we stop this line of execution

Answers (1)