Exam 70-432: Week 1 - The Last Lab Exercises

Finally! The last batch of Lab Exercises, from Chapter 5, Lesson 3:

Practice 1 Populate a Thesaurus

Step 1:

select ProductDescriptionID,Description
from Production.ProductDescription
    where CONTAINS(Description,N' FORMSOF (THESAURUS,metal) ')

ProductDescriptionID Description
-------------------- -----------

(0 row(s) affected)

Steps 2-3:

<XML ID="Microsoft Search Thesaurus">
    <thesaurus xmlns="x-schema:tsSchema.xml">
    <diacritics_sensitive>0</diacritics_sensitive>
        <expansion>
            _metal
            _steel
            _aluminum
            _alloy
        </expansion>
    </thesaurus>
</XML>

Step 4:

use AdventureWorks
go
exec sys.sp_fulltext_load_thesaurus_file 1033;
go

Command(s) completed successfully.

Step 5:



Practice 2 Build a Stop List

Step 1:



 Step 2:

create fulltext stoplist ProductStopList;
go

Command(s) completed successfully.

Step 3:

alter fulltext stoplist ProductStopList ADD 'bike' language 1033;
go

Command(s) completed successfully.

Step 4:

alter fulltext index on Production.ProductDescription
    set stoplist ProductStopList
go

Command(s) completed successfully.

Step 5: