We are very excited to introduce a new Statistical Semantic Search feature with Fulltext Search in Denali. With an optional new parameter ‘statistical_semantics’ you can now augment your Fulltext keywords index with two new indexes – one that captures top 100 statistically relevant words from a document and another that based on these relevant words, captures the top 10 similar documents in the same table. All together now Fulltext search not only allows you to search for a keyword efficiently, but also discover statistically relevant insight through prominent words and similar content.

We are providing you a compressed zip folder SQLSearchDemo that contains following documents and samples that should help you get started with all the new great features in Fulltext Search for SQL Server ‘Denali’ Release.

  • SQL Server Denali Fulltext and Semantic Search Features - Deep Dive Presentation
  • Fulltext and Semantic Search Features Demo Script for AdventureWorks Denali CTP1 Sample Database
  • Fulltext and Semantic Search Features Demo Script using Denali’s new FileTable feature
  • SQL Server Technical Articles Dataset for integrated Fulltext, Semantic and FileTable Features demo
  • Demo Instructions

We thank you for your active involvement during the development cycle of these features and are very much looking forward to your feedback from your test runs and live workload deployments!

PS: blog updated with new attachment for zip file.