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 |
|
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 Queries2.Select * From BI_SERVICE_HEADER where BSH_pat_NUM ='IP/121203/00007'This Query in 1 Sec1.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 |
 |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Query Timeout