What’s New in SQL Server 2008 Full-Text Search
Microsoft spent more than five years developing SQL Server 2008 R2. The developers at Microsoft spent that time improving the engine, tools, and performance and making this version more user friendly. SQL Server 2008 introduces the following for Full-Text Search:
• Full-text catalogs are now stored inside the database. In previous versions, they were stored in the filesystem.
• SQL Server execution plans are able to make intelligent queries against the full-text catalogs.
• Stop lists (also known as noise words files) are now stored in the database. You can create any number of stop word lists; each full-text index table or indexed view can have its own specific stop list.
• You are able to use ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
