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 |
|
krishna_yess
Yak Posting Veteran
81 Posts |
 Posted - 2009-10-14 : 05:28:33
|
| I am using view of remote sql server. The sever has got lot of data. and i have only read access. If I query using SQL client from my PC, it takes minutes together, some times hours, to run the simple select query.is there any thing i have to do in my SQL client? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-10-14 : 08:15:24
|
| Upgrade you line or run all of your queries on the server and pull back the results in a file. Everytime you run a query via Management Studio, it pulls the results back to your client, so if you have a big resultset being returned, it will take a long time.There is nothing in SQL itself that will help you with this. |
 |
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-14 : 08:24:28
|
| Indexing your columns may help.[/fail at query] |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-10-14 : 09:02:07
|
quote:
Originally posted by winterh
Indexing your columns may help.[/fail at query]
Thats a very broad area and answer. It doesn't help to just go throwing indexes at a database, especially if there really is a LOT of data. Secondly, as the OP has read only access, how do you suggest they go about adding indexes? |
|
|
|
|
|
|
SQL server is very slow