Viewing 15 posts - 9,541 through 9,555 (of 49,571 total)
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...
March 26, 2014 at 6:06 am
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...
March 26, 2014 at 5:07 am
March 26, 2014 at 2:40 am
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...
March 26, 2014 at 2:27 am
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...
March 26, 2014 at 2:19 am
Cody K (3/25/2014)
Why did statistics need to be updated when attaching to the new version of SQL Server?
It was mainly needed when upgrading from SQL 2000 to SQL 2005,...
March 26, 2014 at 2:15 am
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...
March 25, 2014 at 11:26 am
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...
March 25, 2014 at 11:23 am
Table definitions, index definitions and execution plan please.
March 25, 2014 at 9:42 am
Bulk inserts (bcp) don't by default fire triggers, but afaik all update operations fire update triggers.
March 25, 2014 at 7:07 am
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...
March 25, 2014 at 6:22 am
Duplicate post. No replies to this thread please, replies to: http://www.sqlservercentral.com/Forums/Topic1554328-392-1.aspx
March 25, 2014 at 6:00 am
How does the procedure return that? Return code, output variable or resultset?
March 25, 2014 at 3:30 am
You restore the full backup from 8am and the differential from 12. They're differential backups, not incremental.
March 25, 2014 at 2:39 am
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...
March 24, 2014 at 3:33 pm
Viewing 15 posts - 9,541 through 9,555 (of 49,571 total)