Not repairable. Restore from a clean backup.

Looks like the IO subsystem zeroed out a couple of large chunk of that data file. You may want to do some further investigation...

Please run the following and post the full, complete and unedited output (I can't diagnose from a snippet). Zip text file and attach if it's huge.

DBCC CheckDB ('<database name>') WITH...

Chapter 4: http://www.red-gate.com/community/books/accidental-dba

The maximum size of TempDB, like all other databases, is ~525 000 TB, so that's the limit to how many rows you can put into a Temp Table. Probably a...

If you PM them to me I'll delete them (not a private consultant any longer). The reason we're asking for them to be posted here is so that anyone wandering...

It was mainly needed when upgrading from SQL 2000 to SQL 2005,...

If the requirement is to remove duplicate rows, use DISTINCT

If the requirement is to produce aggregates with grouping, use GROUP BY

Seeing Group By with no aggregates suggests that someone read...

Steps 1 and 3 aren't needed and I explained in the earlier post that the stats update was required after you upgraded the DB to 2012, not after changing compat...

Table definitions, index definitions and execution plan please.

Bulk inserts (bcp) don't by default fire triggers, but afaik all update operations fire update triggers.

Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

First thing, remove the join hints.

What's the definition of the string splitting function you're using? If it uses a...

Duplicate post. No replies to this thread please, replies to: http://www.sqlservercentral.com/Forums/Topic1554328-392-1.aspx

How does the procedure return that? Return code, output variable or resultset?

You restore the full backup from 8am and the differential from 12. They're differential backups, not incremental.

Try restore the backup you suspect is damaged. Worse case it won't restore, you're no worse off that way.

As for the old backup, if it's a choice between that and...