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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-25 : 11:00:16
|
| nauman writes "i am using four tablesfirt table name ......CALLS having 4,00,000 records.2nd table name ....subaccounts having 20,000 records.3rd table name ....cards having 15,000 records.4th table name.....radconfigs having 50,0000 records.i made a query on tablesi used where clausei used min() functioni used group by clause.in the end i received an error that my query has been timed out.i don't know how can i simplify my query having a lot of records.i can mail u query.before mailing u the query can u help me .....i don't have the concept of views ..... but i heared that views are very useful against table(physical existence)i increase the query time out time in SQL server 6.5 but invain..help me immediatelythanx in advance for giving me info in detailiv alot of question to make my server efficient .... but these should later.once again thanx in advance for replying me ........" |
|
|
|
|
|
i want to get rid of the error of [Microsoft][ODBC SQL Server Driver]Timeout expired