My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/sp_help_fulltext_columns poor performance
The new RSS feed is here
if you look at the internals of sp_help_fulltext_columns, you will see it uses the very common means of handling optional parameters
in the where clause it says (
@table_name is null or
sobj.id = @objid
and
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/sp_help_fulltext_columns poor performance