Garadin (11/26/2008)

---

You may be able to restore the db and the transaction logs up to the point of your bad update query if you have the right logging...

No, they don't...

What does the query for the report look like? Can you do the calculation there?

Ok, I've never actually tried running both. Isn't needed. If what you want is to take a log backup and switch the DB into recovery to prevent more changes before...

No version of SQL 2008 will run on Windows 2000. Below are the supported OS's for 2008 Express

Windows XP SP2 Home, Professional, Tablet, Media Center

Windows Server 2003 Small Business Server...

Bottom line, a good index is one that queries use.

Take a look at the queries that run against that table. Look at what's in the where clause, what the join...

Could you please explain a bit more what you're trying to do? I don't understand the question.

(Repeating post from http://www.sqlservercentral.com/Forums/FindPost609293.aspx)

Run all queries that affect that table with the execution plan option enabled. See which indexes they are using. Remove any that aren't used by any query....

Thread continues here: http://www.sqlservercentral.com/Forums/Topic609292-5-1.aspx

In the interests of keeping things together, no more replies to this thread please.

I'm not familiar with SQL 7. In SQL 2000's query analyser there was a button on the toolbar. If it's not ther, try SET SHOWPLAN_ALL ON, though that's a lot...

Run all queries that affect that table with the execution plan option enabled. See which indexes they are using. Remove any that aren't used by any query. make sure you...

I'm not touching that with a 10 foot barge pole.

Just heard back and that does look like a driver issue. The Broadcom is known to give issues, no ideas about the others. MS won't write articles about other people's...

Optimise the queries so that the run as fast as possible and can use the indexes that you create.

Prior to SQL 2005, the only way is to drop the index.