Jeffrey Williams (12/28/2008)

---

I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is...

ALZDBA (12/28/2008)

---

Does this point to a table that contains text or image columns ?

Try to export the data without these column, so you only lose the text/image stuff if these...

If it's not marked as a deprecated feature (which, if you check, DBCC DBReindex and DBCC...

Does your copy of Books Online say that CheckIdent is deprecated?

Why don't you come...

Well, DBCC certainly is old. Some of the commands have been around since SQL 6, but then that's true for a select statement too.

Many of the DBCC statements are deprecated...

He's a repeat offender who just doesn't seem to get it. I have several unpleasant memories of that guy's...

leonp (12/27/2008)

---

Also, you mentioned single row inserts .... was that based on the logs or profiler output I shared ... I thought the app was running transactions spanning 10,000 row-inserts....

leonp (12/27/2008)

---

when I run bulk inserts from the flat file into the SQL server, (which is ~thrice the total volume read), 35 million rows (18G) are loaded in server...

Lots more. See - http://www.microsoft.com/learning/mcp/certifications.mspx

Reindexing is not going to fix this. There's corruption in the data pages (index id 0). If it was only in the nonclustered indexes (index id 2 and higher) then...

Did you backup using the management studio gui? If there were two files listed in the...

I posted a link to a doc about tran log management earlier in the thread.

You're pulling the entire of two tables, amounting to a total of 15 million rows. That's never going to be quick and there's no way indexes are going to help...