The table is a list of all US Cities, and the person who created the table used all CAPS.

Thanks

i am aware that you need seperate development and production environment. I just dont have this project finshed yet, which is why it is not production ready:)

It is my first...

Nicholas Cain (3/5/2010)

---

It could be any number of things.

You need to take a look at the way memory and cpu are being handled, whether it's the page draw that's causing...

Having SQL Server and your Web Applications is a big security risk...

.....Learning as i go, its not live yet so i will buy a web server.

Is this the production environment?...

External application.

I know that SQL Server and Exchange need to be on different servers, but did not know that one needed to have a dedicated web server as well:(

Do you...

And...you are trying to returns 59k records to the web server?

I dont have a dedicated web server but i am returning 59k records to the web site, but one...

What OS's are used on the DB Server and Web Server?

The same server is running SQL Server 2008 DB and the Web application using IIS. Windows Server 2008 o/s. Is...

Thanks!

CirquedeSQLeil (2/20/2010)

---

Was the disk defrag performed while sql server was stopped?

Second, did you try creating a clustered...

Defragged all drives and rebooted the server, no improvement in query performance 🙁

CirquedeSQLeil (2/19/2010)

---

isuckatsql (2/19/2010)

---

I got perfmon running and did a test on my 60 GB DB accessing 2.25 Million records.

During a 2 minute test, it accessed approx 155 000 records,...

I got perfmon running and did a test on my 60 GB DB accessing 2.25 Million records.

During a 2 minute test, it accessed approx 155 000 records, results below....

I ran the sysprocesses query, but dont know what i should be looking for.

Server has FSAGENT apprearing a lot, but this was the wait that had the hotfix issue from...

Nothing else running on the server!

I did notice a hotfix for a bug, which seems to incorrectly provide a high value to one of the wait tasks.

But that just seems...

In the activity monitor on the Server i have Waiting Tasks(7)....whatever that means ?

I have Waiting Tasks(0) on the desktop.