Create Table t1 (a int, b char(1), c int);
GO

Declare @i int
set @i = 1
while @i < 10000
begin
	insert t1 values(@i, char(@i%65 + 65), @i - 1)
	set @i = @i + 1
end
GO

create statistics stT1a on t1 (a);
create statistics stT1b on t1 (b);
GO

dbcc show_statistics ('t1', 'stT1b'); -- 41 rows
GO

Truncate Table t1;
GO
dbcc show_statistics ('t1', 'stT1b'); -- still 41 rows. truncate leaves stats intact
GO

insert t1 values(1, 'a', 0);
GO
dbcc show_statistics ('t1', 'stT1b'); -- still 41 rows, insert doesn't affect them either
GO

SELECT * FROM t1;
GO
dbcc show_statistics ('t1', 'stT1b'); -- still 41 rows (select * doesn't care about stats)
GO

-- now execute a query that will utilize statistics
select * from t1 where b = 'Y';
GO
dbcc show_statistics ('t1', 'stT1b'); -- 1 row (header row only)
GO

drop table t1;
GO