Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

timeout issue

Status
Not open for further replies.
habesha

habesha

Programmer
Oct 30, 2006
68
US
My datacase is sql 2000,

I am trying to join the tables with a datatime column. It tiime outs, I am trying to optimize this issue.
if I create a nonclustered index on this, does this help
or what is the best solution for this problem

thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
285
ggriffit
ggriffit
Cpreston
  • Locked
  • Question
Timeout Expired Issue 1
Replies
10
Views
397
Cpreston
Cpreston
Ikatiemarie
  • Locked
  • Question
Sp_send_dbmail permissions issue
Replies
0
Views
246
Ikatiemarie
Ikatiemarie
Cpreston
  • Locked
  • Question
Join Issue 1
2
Replies
29
Views
805
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
Are this query below have problem on performance issue ?
Replies
1
Views
172
ahmedsa2018
ahmedsa2018

Part and Inventory Search

Sponsor

Back
Top