Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Performing search on MS SQL Server 2008 database
September 11, 2009
We have built an ASP.NET application (with C#.net language) and hosted on Windows Server 2003 Operating System.
The database is MS SQL Server 2008.
Now we need to do a search involving 4 tables and one of the column of table is varchar (2400) and the other columns are of normal lengths (E.g. Varchar(50) etc.). This search gets fired whenever an user enters a keyword in the search box and presses enter key. The number of searchable records in future could be in lakhs.
Would you please let me know the best method of searching these tables?
If would be great if you could provide a reference document or web reference (If needed).
Posted Date: September 12, 2009 Points: 5
You should go for full Text Search search concept available in sql server please refer this article to get details of Full text search engine..
Mark As Answer
" if this post help you.
To post reply
Related Questions Related Questions
Taking incremental backups from MS SQL Server 2008 Database
Sql SERVER 2008 ,automatice add all table of database this code what is problem plz suggest me
Image store in Database SQL SERVER
Upgrade from SQL Server 2000 to SQL Server 2008
Copying Data from SQL Server 2008 to SQL Express
SQL Server - Database Design - Best Practices
SQL Server 2008 - Table - Clarifications
How to insert data of selected checkboxlist control in database.. (sql server)
How to install softwares on client computer from server computer in Visual Basic.Net 2008.
Sql Server 2005 to sql 2000 database conversion
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend