Although this is an old post, it shows up as first reply on my search in Google.

Answers above, that it's impossible to create nonclustered indexes in a tabletype are outdated.

As...

The description of Full-text Search for Sql Server 2008 R2 says about the Filter Daemon Host Process:

"The filter daemon host is a process that is started by the Full-Text Engine....

I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.

If you use DBCC DROPCLEANBUFFERS between the queries, caches are emptied...

In Query Analyzer (or SSMS 2005 Query window) you can use Options from the Tools menu for the format of "Script Object to...".

In Options on Script-tab you can set "Identifier...