Viewing 15 posts - 38,716 through 38,730 (of 49,552 total)
What did you install and what did you mean to install?
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 3, 2009 at 12:48 am
Holger Degroot (6/2/2009)
Hi Paul,yes it was the first and only error.
If that's the case, I would suggest two things before you try a fix.
1) Evaluate your IO subsystem - check...
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 3, 2009 at 12:45 am
It means pretty much what the error says. The view cannot be schemabound because to do so all tables and functions must have a 2-part name (eg dbo.table1). Marcus said...
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 3, 2009 at 12:45 am
Jeffrey Williams (6/2/2009)
Nope - SQL Server 2005 SP3 and had the same experience on 2005 SP2 CU7.
Odd. I've played around with RECOMPILE on these before and on 2005 I always...
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 3, 2009 at 12:38 am
Paul, could the previous error have been hiding these, or do you think they're new corruptions?
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 2, 2009 at 5:20 pm
Check the error log. Are there any errors relating to those databases 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
June 2, 2009 at 5:03 pm
They're accurate since the last server start. I would still do some analysis before dropping any indexes.
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 2, 2009 at 5:02 pm
Holger Degroot (6/2/2009)
hi Gail,this worked out. Thankx a LOT!!!!
Excellent. I'm glad to hear that.
I don't understand the errors (sorry, don't speak or read German) so I can't advice you on...
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 2, 2009 at 5:00 pm
Check the error log. There should be some entry in there saying why MSDB is suspect.
Do you have a backup of MSDB?
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 2, 2009 at 4:59 pm
Recovery model has nothing to do with performance. It has to do with recoverability of the database.
If you don't care about losing transactions, set the DB to simple recovery....
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 2, 2009 at 4:58 pm
tikkani.praveen (6/2/2009)
Can you give me the exact procedure to follow to take backup.
Look up BACKUP DATABASE in Books online. If you have questions after, please ask them.
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 2, 2009 at 4:46 pm
Jeffrey Williams (6/2/2009)
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 2, 2009 at 4:43 pm
TheSQLGuru (6/2/2009)
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 2, 2009 at 9:49 am
I feel like I'm talking to a brick wall here.
http://www.sqlservercentral.com/Forums/FindPost727250.aspx
Why do people keep defending that query form even in the face of evidence that it performs terribly?
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 2, 2009 at 9:43 am
Could be bad estimates. Haven't checked exec plans in detail. Check that the statistics are up to date (maybe do an update with full scan). If not, go with the...
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 2, 2009 at 9:39 am
Viewing 15 posts - 38,716 through 38,730 (of 49,552 total)