Viewing 15 posts - 36,316 through 36,330 (of 49,562 total)
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.
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/
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...
October 14, 2009 at 2:12 pm
s ss (10/14/2009)
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...
October 14, 2009 at 1:55 pm
s ss (10/14/2009)
October 14, 2009 at 10:20 am
Alvin Ramard (10/14/2009)
GilaMonster (10/14/2009)
Bob Hovious 24601 (10/14/2009)
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/
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...
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,...
October 14, 2009 at 10:04 am
Silverfox (10/14/2009)
You say avg, but over what period ?
Over whatever interval the perfmon samples were done. Default is every sec.
The name of the counter is Physical disk:Avg sec\read.
October 14, 2009 at 10:04 am
Bob Hovious 24601 (10/14/2009)
October 14, 2009 at 9:59 am
WillC9999 (10/14/2009)
October 14, 2009 at 9:57 am
Seth Lynch (10/14/2009)
Repair_allow _Data_loss does not mean there has to be data loss though so your solution was probably fine.
The majority of the time it does. There are a few...
October 14, 2009 at 9:51 am
The read's a little high on the data. Should be < 10ms. I've seen worse though (far, far worse)
October 14, 2009 at 9:45 am
Viewing 15 posts - 36,316 through 36,330 (of 49,562 total)