SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query Timeout
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

raguyazhin
Posting Yak Master

India
105 Posts

Posted - 12/24/2012 :  01:03:33  Show Profile  Reply with Quote
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

Edited by - raguyazhin on 12/24/2012 01:05:52

bandi
Flowing Fount of Yak Knowledge

India
2169 Posts

Posted - 12/24/2012 :  02:45:23  Show Profile  Reply with Quote
May be that record is locked by some other user....

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 12/24/2012 :  15:35:44  Show Profile  Reply with Quote
use sp_who2 for identifying any blocking issues.

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000