Viewing 15 posts - 25,501 through 25,515 (of 49,552 total)
Rich Yarger (6/14/2011)
What a bunch of Alecs! Yes - the smart kind!😛
And you're surprised why?
😀
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
June 15, 2011 at 12:21 am
Not sure what your question is.
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
June 15, 2011 at 12:13 am
Where did that total come from, and have you checked Books Online?
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
June 15, 2011 at 12:11 am
mya (6/14/2011)
The developers can't do anything to prevent deadlocks.
Translation, they're too lazy to try...
I can only run a trace to see the deadlock graph. I am thinking what...
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
June 14, 2011 at 3:17 pm
The problem is in an XML index, not a normal index. The XML indexes need to be dropped and then recreated.
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
June 14, 2011 at 2:07 pm
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
June 14, 2011 at 8:06 am
mohan.pariveda 18256 (6/14/2011)
Try to executeSP_ResetStatus ---- to bring DB online
or
"Restore Database Database_name with Recovery" to bring the Database Online
Those are for suspect or restoring databases, not recovering. Recovering...
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
June 14, 2011 at 8:06 am
Post the latest error log (you can disguise the names of the DBs, they're not important)
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
June 14, 2011 at 7:47 am
Are you sure there are no messages in the error log?
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
June 14, 2011 at 7:18 am
There should be messages in the log.
Check the database state (state_desc in sys.databases). What is it?
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
June 14, 2011 at 7:06 am
This is not repairable in any way. You're going to have to recreate the database from scratch.
Script all objects, most will likely fail because of the schema corruption, I hope...
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
June 14, 2011 at 7:05 am
Do you want the bad news or the worse news?
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
June 14, 2011 at 6:55 am
Steve007 (6/14/2011)
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
June 14, 2011 at 6:51 am
Fail over to the mirror. CheckDB that.
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
June 14, 2011 at 6:50 am
Watching it. 😛
In an ideal world, from a load test on a Test Server, but we all know how likely that is.
To expand, monitor TempDB and see how large it...
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
June 14, 2011 at 6:32 am
Viewing 15 posts - 25,501 through 25,515 (of 49,552 total)