Viewing 15 posts - 41,536 through 41,550 (of 49,552 total)
xanthos (1/21/2009)
Update:I've restored last nights backup of master as a userdatabase and run DBCC CHECKDB ALLOW_DATA_LOSS.
This solves the consistency errors.
Yes, it's fixed the corruption, but do you know...
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
January 21, 2009 at 6:30 am
Andrew Gothard (1/21/2009)
the advice about driving off a cliff
Depends. On occasion I have given such a warning even though the OP was short of manners. It's got me sworn at...
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
January 21, 2009 at 6:21 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640326-149-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
January 21, 2009 at 12:17 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640430-147-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
January 21, 2009 at 12:13 am
ashepard (1/20/2009)
A temp tables are formed for rows fetched
They are?
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
January 20, 2009 at 11:56 pm
Please post table definitions, index definitions and the execution plan (saved as a .sqlplan file, zipped and attached)
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
January 20, 2009 at 2:34 pm
Oh, and the value passed to @LocaleID shouldn't have brackets around it. A couple lines below the other one.
The new error is saying the XML is invalid. You'll...
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
January 20, 2009 at 2:29 pm
mlang (1/20/2009)
EXEC Program_UpdateOptionSetting @OptionID = @optionID,u5@optionTypeID = @optionTypeID,
@ObjectID = null,
@Value = @valueID,
@LocaleID = (31001),
@CallingUserID = null,
@CallingWorkstationName = null,
@Success = null;
I don't think that u5 is supposed to be there.
If you...
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
January 20, 2009 at 2:18 pm
Is your database case sensitive? What's the DB collation?
I know there are some strange behaviours around hierarchyid in case sensitive databases.
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
January 20, 2009 at 2:01 pm
It should be in the default trace. I think Audit Server Shutdown is an event (haven't checked though). The function to get trace data into a table is fn_trace_gettable
The other...
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
January 20, 2009 at 1:36 pm
Do you have a backup of master? repair is not the recommended solution, especially not for a system database.
Can you please run the following, copy the results to a text...
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
January 20, 2009 at 1:25 pm
Is the database you're running it from in compat mode 90? If, say, you're running it from master and using 3-part names to refer to the proc, then it will...
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
January 20, 2009 at 1:23 pm
homebrew01 (1/20/2009)
But, if they were critical, what would be the best method to recover ?
Restore the backup. The preferred solution to any such form of disaster is to...
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
January 20, 2009 at 1:19 pm
Andrew Gothard (1/20/2009)
Well, that depends largely on the attitude of the OP, Gail.
What does? The solution to exact specs or the advice about driving off a cliff? Or something else?
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
January 20, 2009 at 1:16 pm
Can you please load up management studio or query analyser and test the query out there.
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
January 20, 2009 at 1:12 pm
Viewing 15 posts - 41,536 through 41,550 (of 49,552 total)