Clarification. Unless you're running it with a repair option when there is corruption.

If you've configured alerts, you get alerts. If not, you don't (how would SQL intuit who to send alerts...

CREATE TABLE Blah (

ID int identity,

SomeDate DATETIME

-- other fields

)

CREATE CLUSTERED INDEX idx_Blah on Blah (SomeDate)

ALTER TABLE Blah ADD CONSTRAINT pk_blah PRIMARY KEY NONCLUSTERED (ID)

What's the error?

Are there any full machine backups running? Possibly via the VM host?

Nope.

MOC Ewez (11/29/2012)

---

What is wise for a PK seems to be highly debated amongst the pros. Some say it should be a short as possible "Description" of what your table...

Generally when dealing with a performance problem, knowing what tables are hit often is not very useful. Knowing what queries run often is.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

MOC Ewez (11/29/2012)

---

Without of course. 🙂

What you want to do is compare the columns the stats are on and see if you have...

That's not a useful error. Log the job output to a file and check what's in the file.

You can run integrity checks after taking a backup, but personally I prefer...

MOC Ewez (11/29/2012)

---

I guess i need a recursive CTE or pivot into # table then group by and count....???

These are still weak spots for me. I think an overly dramatic...

aaron.reese (11/29/2012)

---

My question is , when the update script runs, does SQL update the indexes first, then update the physical records, or does it update the records first, then the...

Well, the first thing that anyone trying to help needs to know is what's causing the jobs to fail. What's the error?

Huh?

What are you asking?

Please don't post multiple threads for the same problem. Can we perhaps keep everything in one thread - http://www.sqlservercentral.com/Forums/FindPost1390289.aspx

Nic-306421 (11/29/2012)

---

I can't remember where I read it, but I thought the 'Process_Indicator' flag - which is 2 (sorry should have mentioned that) indicated its something within SQL Server itself....