Update statistics to incremental for partitioned tables

incremental_statistics.sql

--ALTER DATABASE [MyDB] SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)
SELECT DISTINCT 'UPDATE STATISTICS ' + QUOTENAME(sc.name) + '.' + QUOTENAME(object_name(S.object_id)) + ' (' + QUOTENAME(s.name) + ') WITH INCREMENTAL = ON'
FROM sys.tables T
INNER JOIN sys.schemas sc ON t.schema_id = sc.schema_id
INNER JOIN sys.indexes I 
   ON T.object_id = I.object_id
INNER JOIN sys.data_spaces DS 
   ON I.data_space_id = DS.data_space_id
INNER JOIN sys.stats S 
   ON I.object_id = S.object_id
WHERE 
   DS.type = 'PS'
   AND S.is_incremental = 0
   AND S.name NOT LIKE 'CCI%' --Ignore columnstore indexes