I suggest you spend some time on google, there's lots and lots written on the subject. Also, probably Glenn Berry's hardware book.

*sigh* http://www.sqlservercentral.com/Forums/FindPost1569693.aspx

Grant Fritchey (5/12/2014)

---

In fact, most of the time, when testing queries, I'll run it once without really looking at the time, then run it 2-3 more times and take the...

Elliswhite (5/12/2014)

---

Here are few steps by which you can drive out your SQL database from recovery mode and perform action on it.

First step is to stop the SQL Services

Then change...

Those waits aren't about how the query is written. They occur when SQL has results that it is waiting to send to the client application.

It's not a case of which you do. If you have backups you'd almost always want to restore. There are scenarios however where you'd need to rebuild first to get...

Probably not.

Please note: 6 year old thread.

Please note: 2 year old thread.

You can put TempDB there, but it's an extremely bad idea. If TempDB grows unexpectedly, you could have the server crash because of lack of free space on C.

Please post new questions in a new thread. Thank you.

How many rows in the table?

Can you post the execution plan (actual please) of that simple query with the inaccurate estimations?

So the resultant dynamic query will read:

SELECT IP_Addr FROM...

I can't see any useful covering indexes for that query, so it's probably just a case of the indexes being insufficiently selective and not covering. Cheaper to scan the table...

Did you read the articles I referenced?

Wrong way around, pages don't have indexes, indexes have pages.