Viewing 15 posts - 9,541 through 9,555 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 26, 2014 at 5:07 am
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 25, 2014 at 11:23 am
Table definitions, index definitions and execution plan please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 25, 2014 at 9:42 am
Bulk inserts (bcp) don't by default fire triggers, but afaik all update operations fire update triggers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 25, 2014 at 6:00 am
How does the procedure return that? Return code, output variable or resultset?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2014 at 3:33 pm
Viewing 15 posts - 9,541 through 9,555 (of 49,552 total)