First question should be how many records of the 12,000,000+ are you deleting?

ScottPletcher (9/2/2015)

---

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they...

ScottPletcher (9/2/2015)

---

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those...

ScottPletcher (9/2/2015)

---

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those specific bytes --...

GilaMonster (9/1/2015)

---

It probably did nothing, since the error was in code and repair can't fix that (short of deallocating pages from the system tables)

Why don't you just leave him be,...

Sean Lange (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always use NOLOCK" myth....

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to have to restore the...

Welsh Corgi (9/1/2015)

---

DBCC CHECKDB

( 'database_name'

[ , NOINDEX

...

Ed Wagner (9/1/2015)

---

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to have to...

Right, you did a repair (what ever that is).

Nobody said it would be a quick fix. We said it is what needs to be done in order to prevent the same problem in the future.

It will take...

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to have to restore the database between...

Well, that is going to cause an issue as you have a...

Welsh Corgi (9/1/2015)

---

Eric M Russell (8/31/2015)

---

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed....

Is there a reason that the COMMIT and ROLLBACK are commented out in your original post?