Full-Text catalog properties - SQL Server

Recently I have been working with the Wiki project – just to prove that my desktop PC can be as fast as Windows Azure in hosting and searching through the entire Wiki content.

In order to do that I created a local database which contains all wikipedia articles in XML format and it uses XML indexing and Full-Text indexing to perform the search for keywords and also to rank the results.

The articles are already imported – there are 11,946,951 articles in the database. (There were a few articles which were not imported due to some XML error, but the ones that are imported will be enough to prove a point.)

So, right now I am populating the Full Text search catalog, and while I am doing that I can’t help but ask myself some questions:

how many rows are indexed?

how big is my Full Text catalog?

how do I know when the Full Text catalog is populated?

where is my Full-Text catalog saved?

And since I am a lazy kid, I like to answer my questions with T-SQL code and save the code for later reuse.

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )