Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Searching across multiple tables


I'm using mssql server 2005 Ent.  I have five tables with two columns
that are of type:

- varchar(250)
- varchar(max)

There are other columns in these tables but the above two are always
there.  What is the best way to look for keywords in all of these
tables but only in the above two columns?   LIKE with wildcards is an
option but I was wondering if there is any benefit to using fulltext
cataloging or some other method.  These columns aren't indexed.  Only
the IDENTITY columns, which are clustered and a primary keys.

Thanks,
John

John,

Full text indexing would give you a lot more capability such as word
stemming, proximity ranking, relevance ranking, etc. In SQL Server 2K it
takes a lot of horsepower to manage, and there are performance issues with
large catalogs. According to MS, full text indexing performance has improved
considerably:

"For example, on the same hardware, with the same data set, building a
full-text index on 20 million rows of character-based text data took roughly
14 days in SQL Server 2000, while in SQL Server 2005, the same index
required less than 10 hours."

I have not run any performance tests on SS 2005, but I think it might be
worth your time to prototype it and see.

-- Bill

"john_c" <j@bigstring.com> wrote in message

news:1173293768.301564.246680@64g2000cwx.googlegroups.com...

Consider implementing Full Text Search ...

--
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--

"john_c" <j@bigstring.com> wrote in message

news:1173293768.301564.246680@64g2000cwx.googlegroups.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc