Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pandaface
Starting Member
2 Posts |
 Posted - 2011-04-20 : 11:32:49
|
| Hi everyone! Hope you can provide me some direction with my questions:I've been working at a job for just over a year now doing tech support for clients. This required querying the database and such, so I have a basic understanding of SQL.My job is to create incident tickets for the other employees and myself to work on. These keep track of our performance and such, and they are saved in our own SQL database.The need for a way to find similar past incidents for newly created tickets has arisen. The best way I can think of doing this is to have a way to search a for fields with the same words in it.Am I making sense?Basically, I want a way to "google", per se, our database for similar incidents to newly created ones. Can anyone offer help here? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-20 : 11:36:31
|
| Full-text indexing and search is probably your best bet: http://msdn.microsoft.com/en-us/library/ms142571.aspx |
 |
|
|
pandaface
Starting Member
2 Posts |
Posted - 2011-04-20 : 12:03:00
|
| Thanks for the quick response! I'll see where this takes me. |
|
|
|
|
|
|
SQL Search Engine