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
 General SQL Server Forums
 New to SQL Server Programming
 Time Out Expire

Author  Topic 

venkateshnaikd
Starting Member

1 Post

Posted - 2010-08-17 : 02:36:00
Hi,
I have a table which has millions of rows when i pass a query time out expire occurs.

Thanks in advance.


Venkatesh N

Sachin.Nand

2937 Posts

Posted - 2010-08-17 : 02:40:27
How many rows are you returning from your table?


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-17 : 10:20:02
do you have any proper index which can be used by query in table?

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

Go to Top of Page

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-08-17 : 13:13:25
maybe you have an option set in SSMS (2005+) under
tools -> options -> Query Execution -> Sql Server -> General: Execution Time out
Go to Top of Page
   

- Advertisement -