in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL Server 2005 » Full Text (RSS)

Browse by Tags

  • SQL Server 2008 – iFTS Introduction

    This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while. Firstly an introduction to full text. Full text is the feature in SQL Server that allows you to search text content...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 19 2008

  • Office 2007 iFilters are now available

    The ifilters needed to index office 2007 documents are now available for download from here http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en At the time of writing some of the related KB articles aren't available. If you use full text...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 18 2007

  • XmlTextWriter produces processing instruction

    This week I've been producing XML Thesaurus files for SQL Server. The prupose is to enable spell checking in full text. The thesaurus file is an XML file wih a defined schema, I was creating the file with an XmlTextWriter but couldn't for hte life of me get it to load. After much digging I realised...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Sep 22 2007

  • PDF 64 bit iFilter at last

    If you use full text and wat to index pdf documents you might have found you run into problems on a 64 bit machine. This is because there is no 64 bit iFilter for pdfs. The iFiliter is the bit of code that interprets the code and spits out the information for the search service (full text) to use to...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jul 18 2007

  • OLAP or Relational? Its all irrelevant

    Chris Webb has mentioned an article about Ralph Kimball that discusses the what tool you should be using at the end of your BI process to present back to users. Should it be OLAP based or Relational based. We had exactly the same discussion in the pub after the UG meeting last week. In my view its just...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, May 4 2007

  • Full Text Delay for first search

    If you use integration services you may have encountered an issue where the service won't start. One cause of this is that the service verifies certificates at startup and for this it requires an internet connction, if your server doesn't have an internet connection the startup will fail. The...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Nov 11 2006

  • SQL Engine - Storage of Large Object Data

    If you are currently using text, ntext or image data in SQL 2000 and are looking to use "max" data types in SQL 2005 you will be interested in my first article for SQLServerCentral on the use of LOB data . The point I cover is the storage of data in and out of row and that the default behaviour...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 4 2006
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems