Large Full text management

Posted on 2009-04-24
Last Modified: 2013-11-05
I have a database we are porting from Oracle to SQL 2008. One of our tables is 22,000,000 rows of data and need to do a full text index on it.  There are 3-4 fields that need to be part of the index.  I need to do fuzzy logic searching. Ideally, I would like to have a spelling checker, custom stop words and synonym database.  There is between 10K lookups per day returning average of 500 results that will come via .NET web application.  Around 5000 Add/Delete/Updates per day on low side, 10,000 on the high.  

Should I be using SQL 2008 out of the box or look at 3rd party indexer or applications.  I have not had much luck finding expert level articles on how to maximize the Full text index of SQL Server.  Does anyone have more feedback or resources for information.  
Question by:egarrison
    LVL 51

    Accepted Solution

    LVL 51

    Expert Comment

    by:Mark Wills
    Oh, and one more (you could link to from the above) but worth pointing out it talks about new things, but there are a couple of points about performance which should interest you...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now