K12IT

My current project requires searching for key words across PDF documents and so I spent some time researching on indexing and searching.

 Most of  the data that I needed to search on is stored in Text and BLOB columns. The site below was particularly helpful in understanding the use of iFilters and how to install iFilters for Adobe.

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Another web blog I found helpful in gaining additional theoretical knowledge on various  kinds of indexes is show below.

SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages.