Viewing 15 posts - 36,301 through 36,315 (of 49,552 total)
viduvs (10/15/2009)
Is it normal to see such state?
If you have autoclose on, yes. When SQL brings a DB online, it does restart-recovery. It has to.
That you're seeing if for couple...
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
October 15, 2009 at 4:07 am
ericwenger1 (10/14/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
October 14, 2009 at 11:50 pm
Bob Hovious 24601 (10/14/2009)
Which galaxy?
This one. What would be the point of conquering any other?
Before anyone gets worried...
Currently playing Altarians going for an ascension victory. Just need to do something...
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
October 14, 2009 at 11:49 pm
s ss (10/14/2009)
GilaMonster (10/14/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
October 14, 2009 at 11:46 pm
Better, but not fantastic.
There's still a massive inaccuracy on the row estimation coming from tblRegularItems. I don't understand why. Try an update statistics with full scan on that table, even...
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
October 14, 2009 at 11:32 pm
I haz two tables and no question
http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx
Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy, then going to bed.
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
October 14, 2009 at 2:19 pm
And your question is.....??????
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
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
October 14, 2009 at 2:16 pm
Bob Hovious 24601 (10/14/2009)
May The Thread forgive me for actually posting code here.
Go meditate on your failures, say 20 'Hail SQL's and sin no more.
(apologies to any Catholics, no insult...
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
October 14, 2009 at 2:12 pm
s ss (10/14/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
October 14, 2009 at 2:02 pm
Slick84 (10/14/2009)
Would you be able to explain what the wide disparity between the two numbers signifies?
The optimiser estimates one row and hence generates a plan that's optimal for a very...
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
October 14, 2009 at 1:55 pm
s ss (10/14/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
October 14, 2009 at 10:20 am
Alvin Ramard (10/14/2009)
GilaMonster (10/14/2009)
Bob Hovious 24601 (10/14/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
October 14, 2009 at 10:17 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
October 14, 2009 at 10:09 am
ericwenger1 (10/14/2009)
Here is my solution and wanted opinions:USE [master]
GO
ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [msdb] SET SINGLE_USER
GO
DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [msdb] SET MULTI_USER
Repair, especially 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
October 14, 2009 at 10:07 am
Seth Lynch (10/14/2009)
Incorrect PFS free space information for page (1:105428) in object ID 60, index ID 1, partition ID 281474980642816,...
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
October 14, 2009 at 10:04 am
Viewing 15 posts - 36,301 through 36,315 (of 49,552 total)