SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements

SQL Server 2008 Full-Text Search: Internals and Enhancements
SQL Server Technical Article
Writer: Fernando Azpeitia Lopez, Microsoft Corp.
Published: July 2008

Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics, chemical, or multimedia. Search is a key technology capable of working with vast amounts of data: it is scalable, low-latency, and very user-friendly. It is just what is needed to make a database the best place to store all types of data.

SQL Server 2008 introduces a new Full-Text Engine that is integrated into the relational database. Full-text search is now as fully integrated as any other database service. The main goal for full-text search in SQL Server 2008 was to introduce a new integrated Search platform. In addition to the improvements and gains that come with this integration, this platform provides a strong base for delivering, in the near future, innovative new features and capabilities that combine the strengths of searching and querying.

SQL SERVER - Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements fulltextsearch

Read white paper SQL Server 2008 Full-Text Search: Internals and Enhancements

Abstract courtesy : Microsoft

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds

, ,
Previous Post
SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture
Next Post
SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1

Related Posts

1 Comment. Leave new

  • Kindly confirm one thing.
    Is it possible to search by giving half part of the word like ‘youn’ instead of giving ‘young’ by some how using full text search.

    Reply

Leave a Reply

Menu