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.

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

<Sigh>

You can generate a trace script from profiler. All you'll need to do with the script is set an end time and a file name. Script to a fast drive...

You do get the cert, providing you have any prerequisites. You will have to wait a while for results.

That exam's not in beta though. It went through beta some months...