.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Performing search on MS SQL Server 2008 database

Posted By: Venkat     Posted Date: September 11, 2009    Points:2   Category :Sql Server
Hi,
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).


Many Thanks,
Regards,
Venkat. .

Responses
Author: Amit Mehra             
Posted Date: September 12, 2009     Points: 5   

HI

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..

http://technet.microsoft.com/en-us/library/cc721269.aspx

http://msdn.microsoft.com/en-us/library/ms142571.aspx

Thanks,
Amit
Please "Mark As Answer " if this post help you.


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend