CREATE STATISTICS [name] ON [table name(column name] WITH SAMPLE 50 PERSENT

ALTER DATABASE [database name] SET AUTO_CREATE_STATISTICS ON

dbcc show_statistics (table_name, stat_name)