BUG: Statistics Are Printed Twice with Statistics Time On

CAUSE

Auto-parameterization is a new feature in SQL Server 7.0. Using parameters or parameter markers in Transact-SQL statements increases the ability of the relational engine to match new SQL statements with existing, unused execution plans. If an SQL statement is executed without parameters, SQL Server 7.0 parameterizes the statement internally to increase the possibility of matching it against an existing execution plan.

Because the server tries to use Auto-parameterization the query is partially compiled twice. The first time is to parse and Auto-parameterize the query. The second time the query is compiled is when the plan is put into cache.