Archive for August, 2008

SQL Server 2008 Full-Text Search

August 17, 2008

The following is a very good article which covers the improvements to Full-Text Search in SQL Server 2008.


SQL Server 2008 Full-Text Search

Although there is little in the way of new functionality, Microsoft has fully integrated Full-Text Search with the SQL Server Database Engine. In previous versions of SQL Server Full-Test Search was a separate Service (MSFTESQL). This change significantly improves the performance of Full-Text Searches. The following example from the article clearly explains why.

SELECT candidate_ID FROM Candidates
WHERE CONTAINS (Resume,”SQL Server”)
AND candidate_division=534

Assume that in this example, the table named Candidates contains a large number of candidates (rows) containing the phrase ‘SQL Server’, but only a few of this belong to the division 534A. You would expect that the query plan for this query would first find the candidates belonging to that specific division, and then use those results to find who has SQL Server experience. This would be far more effective than using the reverse order.

Full-text search in SQL Server 2000 and 2005 cannot operate this way because it is not integrated with the SQL Server query processor. When this type of query ran, the query processor had no statistics from full-text search to determine the optimal approach, nor did it have a way to push predicates/IDs to the external Full-Text Engine. Thus, previous releases of full-text search had no other solution than to send the full-text predicate to the Full-Text Engine (outside), and then wait for the results to come in order to filter them by a more selective predicate. This is very inefficient.

Advertisements

What we have been up to recently…

August 2, 2008

A lot of the things I am working on at eCommera are commercially sensitive so I am not able to blog about as much as I would like. Whilst I have been travelling a reasonable amount over the last 2-3 months as we build up and expand our near-shore team we have been busy with the following

On-boarding (all going live in 2008)

Business Development

  • Presenting to prospective customers
  • Responding to ITT’s (Invitation To Tender)
  • etc

Product

  • Major release of our Order Management System
  • Preparing for Sterling Commerce v7.11 to v8 upgrade
  • Upgrading retailers from Demandware 2.4 to 2.6
  • Reminder Service
  • BazaarVoice integration
  • SMS integration
  • Amazon Market Place integration
  • Integration Hub Disaster Recovery
  • Technical proof of concept for additional service
  • etc

Recruiting

  • Pre-sales Engineer (London)
  • Project Managers (London)
  • Business Analysts (London)
  • Solutions Architects (London)
  • Web Designer (London)
  • Developers (Sofia)
  • QA (Sofia)
  • etc

Other

  • Many releases containing enhancements for our existing customers
  • Process enhancements
  • Migrated SVN and Incident Management System to new location
  • Incident Management System enhancements
  • Evaluating Knowledge Management Systems
  • Technical Support Survey
  • Implementing Callagenix
  • etc