Check statistics with less than 25% of sample and may require a full scan

check_stats_fullscan_candidate.sql

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED  
SELECT DISTINCT 'UPDATE STATISTICS ' + t.name + '.' + OBJECT_NAME(mst.[object_id]) + ' ' + ss.name + ' WITH FULLSCAN' 
FROM sys.objects AS o
	INNER JOIN sys.tables AS mst ON mst.[object_id] = o.[object_id]
	INNER JOIN sys.schemas AS t ON t.[schema_id] = mst.[schema_id]
	INNER JOIN sys.stats AS ss ON ss.[object_id] = mst.[object_id]
	CROSS APPLY sys.dm_db_stats_properties(ss.[object_id], ss.[stats_id]) AS sp
WHERE sp.[rows] > 0
	AND	CAST((sp.rows_sampled/(sp.[rows]*1.00))*100.0 AS DECIMAL(5,2)) < 25