Yes, stats absolutely matter, and a table scan is not the only option SQL has. It might be able to scan another nonclustered index that has all or some of...

Same way stats that are part of an index are used - to give the optimiser an idea of the distribution of the data uniqueness and an estimate of how...

Please do come, even if it's to just laugh and point.

Jeff Moden (10/11/2013)

---

December is one the best times to look for a job... that's when everyone knows what their budget for next year is and you know the rules... use...

Most likely either the table is a heap or it's too small to bother about defragmenting.

George M Parker (10/11/2013)

---

To know whether your value is good or bad, you have to know what "normal" is. That means that you need to have a baseline value (or...

http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Try an outer join, or join to exec_sessions instead. Session space usage is for all current sessions, regardless of whether or not they are currently running queries. exec requests only...

Correct

So in...

Books Online?

No and never has.

Restore Monday full, Wednesday diff, all log backups from that backup up to the point that you want to restore to.

I said it's not very useful by itself. So alone it tells you nothing. Along with other counters however it can tell you a lot.

If you have severe memory pressure,...

No, it's very useful. It's not...

What, specifically, are the issues?

Buffer pool should fill fast, that's by design (SQL will ramp up buffer pool usage after start up)

SQL will use as much memory as it can,...