You say you truncate the log. What exactly do you mean by that?

Good point. It could very well be that.

Set Statistics IO ON and then do your tests. Check the logical and physical IOs. Physical means it reads from disk, logical...

Index2 is redundant. You should be able to drop it without having an effect

As ALZDBA said, the function will prevent index seeks. Change the query to avoid any function on the columns in the where clause.

Also, the select * makes covering indexes hard....

Is the F drive compressed or encrypted?

Is the index covering? The 90% (often closer to 99%) applies when SQL needs to do bookmark lookups to the cluster/heap

How are you viewing the execution plan?

Selectivity is a measure of how many different values are in the index compared with the number of total rows.

If the values are unique, then you have 100% selectivity.

I don't...

Traceflags 1204 and 1205 are for finding deadlocks, not blocking chains

webrunner (2/29/2008)

---

3. I happened to be copying a backup file (11 GB) off of the server when this problem surfaced. I was copying from a different drive than the OS...

Lynn Pettis (2/29/2008)

---

Since you would ask about Statistics in an interview, what can do you look for in an answer? I have been working with MS SQL Server since...

I did say depending on the position. Someone applying for...

Odd. SQL won't automatically create indexes, only statistics.

Is it possible that someone created that index and gave it the same name as the statistic it was supposed to replace?

Cool.

Any chance of seeing the execution plans? Please?

One thing I notice from that.

You've got a TOP 100% ... ORDER BY in a sub query. It's useless there. Order by only applies in the outer select. It probably...