SQL Searches randomly failing
Posted on 2015-01-22
We are running SQL Server 2014. We have a very large inventory table and a corresponding item site table. We have a very small routine that help the user during date entry. What it does it goes to the first record in the item site table and returns that location. Over the past few months we have noticed that this search will randomly fail. They can type the same part number in a dozen times it works fine and then on the 13th try it fails and then do it another 12 times and it works. I am thinking perhaps a corrupt index or worse yet, the item site table may be becoming physically damaged. What would you suggest be the steps to rectify this issue? We can start with the simplest tasks and then move onto more complex solutions, if needed.