I am struggling on finding easy to follow guides on searching tables efficiently in SQL Server. I am not a programmer but managed to assemble an application that has been very valuable in our daily operations... however.. searching is a pain.
For practical uproses, it's almost impossible to search for annything because of the amount if time it takes to query a large table (lets say 19,000 rows. When it does return results, its basically doing a keyword search until it finds one... stops... and continues. Same like inside a word document.
So, the way this app is setup is we have a basic MS Access 2007 Front-End connected to a very extensive SQL back end. The SQL backend is used by another application; my piece is a small plugin that accesses only small pieces of the overall data.
I would like to be able to add something to this Access 2007 front end that can do full-text queries of two tables. I setup the full-text catalogs and stuff on the SQL server, just dont know how to begin using any of it at the user-level. Key here is that it needs to work simply for the end user -- and needs to be relatively easiy to assemble for me.
Look forward to feedback.