Saturday, 13 September 2008

SQL Statman ??? (Ski-Ba-Bop-Ba-Dop-Bop)

Statman sounds a bit too much like Scatman for my liking and reminds me of a cheesey 90s dance song.

On a serious note, just what are all these Statman() entries in my sql trace?

for example >

SELECT StatMan([SC0]) FROM (SELECT TOP 100 PERCENT [dbname] AS [SC0] FROM [dbo].[#tmp_sp_db_vardecimal_storage_format ....

The short answer is that they are nothing to worry about.
They show an automatic statistics update occuring i.e. are the effect of having AUTO_UPDATE_STATISTICS set to ON.

No comments: