Wednesday, March 10, 2010

Full Text Search and Service Broker in SQL Server 2008

Some basic points to remember before Implementing Full Text Search:
  • Full Text Search scenario come when you have queries beyond the Like clause capabilities against word or phrase.
  •  In SQL Server 2008, Full Text Search service is fully integrated with SQL Server database engine.
  • Search results from data source like PDF which stored as varbinary data type.
  • Search specific word or phrase
  • SBS is a process of sending and receiving asynchronous messages in the same database or between different instances of Sql Server.

No comments: