I updated stats with full scan on the entire table. Should I try just updating them on that particular index?

It was in there, but I re-added it...

Guess I'll try setting up the SQL severity alerts to kick off a SQL job. Then have that SQL job write to the application log.

I should then be able...

Gazareth (3/6/2013)

---

The other way to do it if possible would be to give role membership(s) to AD group(s), and control user membership in AD.

That way you won't need to...

Good catch! Still open to a better overall approach for this.

EdVassie (9/21/2012)

---

There are no performance or integrity advantages in moving the locations of Master, Model, and MSSystemResource databases.

If you make heavy use of msdb then consider moving its files to...

John Mitchell-245523 (9/20/2012)

---

then I...

I'm not really seeing any...

We do have the issue...

This seems to have remedied the problem. DB integ check finished without crashing for the first time in a long time.

SpringTownDBA (8/22/2012)

---

Some advice for the OP, if you can take down your SAN by slamming it too hard, you should consider reducing your hba queue depth to limit the number...

After I had an actual conversation with my SAN guy, it looks like I will be able to scrape up enough spindles to run RAID10 at 200gb's for the tempDB.

I...

Lynn Pettis (8/9/2012)

---

Is this table fairly active regarding Update/Inserts/Deletes? It is possible that the statistics were automatically updated by SQL Server using a sample of the data, whereas the...

Lowell (8/9/2012)

---

rebuilding an index only builds the statistics on the columns included in the index; it doesn't do the whole table. so if the statsitics are out of whack...

Thanks all - for sharing the very useful links and knowledge. I always like to check in here to be sure I have a full understanding, before I make...