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-05 : 09:55:12
|
| prashanth writes "Hi, I have sql server 7.0 version When ever i give select name from table where text like '%com%' It takes a long time for me to fetch data and display. and too worst in my ASP page ... some time page expires And we have huge data's in database and sql server 7.0 is located in C: drive which is free upto some 4 gbsIs there any solution for this problem .can i use some other select statement .Please let me provide with best solution sirThanking youprashanth" |
|
|
|
|
|
Select statement takes long time for querying why ?