Using SQL Management Studio, receiving Timeout Expired message
Posted on 2007-12-01
When I use a simple select statement to query, records return with-in seconds. But when I add the WHERE clause to select the correct records the system said waiting on response for the server & and then after about 30 seconds I get a timeout expired & message. The query is against a new archive BD that will not see much action. I tried to change the settings in Tools - Options - Designers ... but no effect (still times out in 30+- seconds). Because the data will not be used much, I can extend the time-out limit or fix the root cause which I think is related to the keys and indexing. The field that I need to filter on is not a Key/Index.