Viewing 15 posts - 18,871 through 18,885 (of 49,552 total)
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/Topic1288035-391-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
April 23, 2012 at 5:15 am
DBCC TRACESTATUS is how you do it.
Tested:
Window 1:
DBCC TRACEON(3604, 1222, 3605, 1204, -1)
Window 2:
DBCC TRACESTATUS
TraceFlagStatusGlobalSession
1204110
1222110
3604110
3605110
Now the trace has to be enabled globally for you to see it from another connection....
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
April 23, 2012 at 5:14 am
Forget powershell. It's irrelevant.
Please define 'crash'. Exactly what happened? Exactly what state are things now?
Do you have a backup?
Do you have the mdf and ldf files?
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
April 23, 2012 at 5:11 am
The entire and complete, unedited output 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
April 23, 2012 at 5:07 am
Good to hear.
That was probably from ghost cleanup processing all the ghosted rows and being able to deallocate the pages afterwards.
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
April 23, 2012 at 5:07 am
Please run this and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
April 23, 2012 at 3:45 am
Ells (4/23/2012)
When I looked again it really is going to be hard for some of us 'Just BI' people to get through the certification.
Same for 'just dev' or 'just...
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
April 23, 2012 at 3:33 am
sqldba_newbie (4/22/2012)
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
April 22, 2012 at 6:16 pm
Just consulted with an expert. No way to do what you want (assuming that the ghost cleanup doesn't fix, which it may well not)
Create new DB, script all objects, create...
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
April 22, 2012 at 6:07 pm
Firstly see if you can force a ghost cleanup. Connect via the DAC and query the table (select * from sys.syscolpars), see if that gets the (presumedly) ghosted rows removed....
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
April 22, 2012 at 5:24 pm
Can you explain the requirements in more detail 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
April 22, 2012 at 5:20 pm
As a wild guess (because you've provided no data), you have '1' in one table and 'Question1' in 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
April 22, 2012 at 11:37 am
Well given that neither table you posted even has a primary key, I'm going to assume you left something out...
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
April 22, 2012 at 11:19 am
You don't have a select within an insert. You have an insert followed by a select.
That said, you haven't changed the table names in the select to match your tables....
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
April 22, 2012 at 10:34 am
Either change them both or change neither, changing one and not the other makes the query close to impossible and makes no sense at all.
The sample query I gave 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
April 22, 2012 at 10:11 am
Viewing 15 posts - 18,871 through 18,885 (of 49,552 total)