O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Full-Text Search Enhancements

SQL Server 2012 full-text search enhancements include improvements in performance and scale and new functionality, including the previously discuss Semantic Search capability.

Full-text search in SQL Server 2012 now scales to more than 100 million documents. Significant improvement can also be realized in the traditional full-text query performance, which is reported to be approximately 7 to 10 times faster than in the previous versions of SQL Server. Additional performance improvements are a result of improved internal implementation, improved query plans, and preventing queries from blocking index updates.

The new functionality associated with full-text search includes the following:

Property Search—In SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required