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 |
|
drenard
Starting Member
7 Posts |
 Posted - 2007-08-23 : 13:22:49
|
| I get a timeout error when dealing with large table of 200,000 + records. Could someone share with me where/how settings in SQLExpresscan be adjusted.Or should I upgrade to the full version of SQL, My end resultwill have me dealing with 600,000+ records being converted from a flat file to SQL.Thanx in advance.D Renard |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-23 : 13:57:11
|
| Post the query that you are running that times out. Also post the table structure of all tables involved in the query plus all indexes on those tables. Let us know where there are constraints too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
timeout errors