I have couple questions about auto stats in SQL Server:
I know I can use the following statement to check if the database auto stats is disabled, but is there a statement to check if a specific index's auto stats is disabled?
SELECT DATABASEPROPERTYEX('Databasename','IsAutoUpdateStatistics')
If I disable auto stats for an index before my reorg jobs, will it prevent blocking issues in SQL Server?
In the following link there is a statement that you can disable auto stats on a database level https://msdn.microsoft.com/en-us/library/ms188775.aspx