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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query Timeout

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2012-12-24 : 01:03:33
Hi

I ran the following queries in ssms,the first query getting a result in a Sec after i changed a where clause data in a same query but it ran long time and getting timeout error. why this query behave like this.

The Queries

2.Select * From BI_SERVICE_HEADER where BSH_pat_NUM ='IP/121203/00007'

This Query in 1 Sec


1.Select * From BI_SERVICE_HEADER where BSH_pat_NUM ='IP/121203/00008'

This Query in Time out Error.



--
Ragu

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-24 : 02:45:23
May be that record is locked by some other user....

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-24 : 15:35:44
use sp_who2 for identifying any blocking issues.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -