Full Text - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Full Text (RSS)
11 April 2008 16:27

SQL Server 2008 - Breaking bug

If you are using CTP6 of SQL Server 2008 and want to use Integrated Full Text and find it is not working. You might get timeouts or other general errors. It could be due to an account that iFTS uses. iFTS does some stuff out of process for security and...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
20 February 2008 13:06

SQL Server 2008 – iFTS Performance – DocidMap

The next post in the series on iFTS (Integrated Full Text Search) covers one of the major improvements in SQL Server 2008 for Full Text and is related to the Integrated part or iFTS. SQL Server 2005 introduced a huge performance improvement by moving...
Posted by simonsabin | 5 comment(s)
Filed under: , , ,
20 February 2008 12:11

SQL Server 2008 – iFTS Manageability – Loading thesaurus files

The next post in the series on iFTS (Integrated Full Text Search) covers a thesaurus files. A feature introduced in SQL 2005. The loading of thesaurus files is a bit of an uncontrolled beast in SQL Server 2005 (there weren’t supported or documented prior...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
20 February 2008 11:32

SQL Server 2008 – iFTS Transparency – Viewing the words in the index

This is the next in the series of posts about the new iFTS (Integrated Full Text Search) in SQL Server 2008. One of the huge frustrations with using Full Text prior to SQL Server 2008 was that you had no idea what content the iFilter has extracted from...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
20 February 2008 09:40

SQL Server 2008 – iFTS Transparency – dm_fts_parser

SQL Server 2008 – iFTS Transparency – dm_fts_parser In the next in this series of posts on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser. Wow thats a cool function name what does it do Simon? Well in my first...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
20 February 2008 09:38

SQL Server 2008 – iFTS New features

In the previous post I talked about Full Text in general. I will now talk about whats new in SQL Server 2008. I would categorise the new features into Performance, Manageability and Transparency. So what’s new in SQL Server 2008, well we have, 1. Full...
Posted by simonsabin | 4 comment(s)
Filed under: , ,
19 February 2008 17:52

SQL Server 2008 - CTP6 is now available

The next CTP of SQL Serve 2008 is now available for download. Whats different about this CTP from the others, apart from the new features which there are a lot, is there is a bug bash contest that is opening. Simply put the people that raise the most...
Posted by simonsabin | with no comments
Filed under: , , , ,
19 February 2008 15:06

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...
Posted by simonsabin | 10 comment(s)
Filed under: , ,
18 December 2007 23:08

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...
Posted by simonsabin | with no comments
Filed under: , , , ,
22 September 2007 22:51

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...
Posted by simonsabin | with no comments
Filed under: , ,
18 July 2007 00:10

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...
Posted by simonsabin | 2 comment(s)
Filed under: , , , ,
27 June 2007 09:33

Blobs block online indexing

If you are lucky enough to be running enterprise edition of SQL you may have looked or want to look into online index rebuilds. Unfortunately having blobs in your index blocks you from being able to do online rebuild of that index. Cruically what that...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
04 May 2007 09:42

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...
Posted by simonsabin | with no comments
Filed under: , , ,
02 March 2007 10:15

Understanding Full Text Searching Compared with LIKE

One of the most common questions that comes up on the newsgroups is around searching for terms containing punctuation. The questions are normally something like "I'm trying to use Full Text to search my product catalog, when someone enters a...
Posted by simonsabin | with no comments
Filed under: ,
11 November 2006 10:22

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...
Posted by simonsabin | 1 comment(s)
Filed under: ,
More Posts Next page »