Hello all, I'm running a simple select query that brings me 4,5 million rows. The query is Code: select * from blablabla The question is if it is normal to have such a long execution time and also if the network traffic generated is normal to be 1gb of data (the whole db is around 3.5gb large)!!! I'm using Management studio on a LAN and I see transfer rates of around 6-7mb/sec. Obviously if I run this query from home over my DSL connection it would take forever, right..? On the other hand what confuses me is that even if i run the query on the local SQL server, it still takes the same amount of time to complete. Is this normal, and if yes, what can I do to improve the performance? The server is a Dell PowerEdge 2950 with 2x Xeon 5120 (1.86GHz) and 8GB ram with 3 disks in raid5, on a Win2003 x64 running SQL2005 x64.. The server frequently hits 100% cpu usage and I can't find what the bottleneck is. All help greatly appreciated!