Viewing 15 posts - 1 through 15 (of 43 total)
August 1, 2017 at 2:04 pm
That is a good idea... but with this being a DBA forum I was hoping at least one other person has ran across this as well and could possibly share...
May 7, 2013 at 10:35 am
Ok, I tried the recommendation by Grumpy DBA and it worked fine just by extending the SCM timeout from the default of 30 seconds to 60 seconds. This was...
April 22, 2013 at 11:20 am
FYI - I will be trying out the recommendation that GrumpyDBA posted that Dan linked to (above). I'll post the findings here.
April 11, 2013 at 12:50 pm
george sibbald (4/11/2013)
so, to confirm, you were also able to resolve this issue by removing a WINDOWS security patch? (2661254)
Yes, I removed that security patch and Reporting Services started up...
April 11, 2013 at 12:47 pm
george sibbald (4/10/2013)
I'm confused, which KB did you uninstall, (neither number seems correct) and was it a post SP2 patch?
Oops, typo - http://support.microsoft.com/?kbid=2661254
That is the KB number I...
April 11, 2013 at 12:06 am
Yeah, an uninstall of SP2 definitely is the last resort (not even considered an option IMO) for me. My prior statement to uninstalling it was in reference to KB266124,...
April 10, 2013 at 2:41 pm
Thanks for this tip, I have 4 more servers to fix so I'll try this on one of them to see if it works. The odd thing is that...
April 10, 2013 at 12:01 pm
Hey Steve, I think I found something a tad easier - http://support.microsoft.com/kb/323007. Now if anyone is as clumsy as I am they have a way to copy...
April 9, 2013 at 2:12 pm
Steve, thanks for the link. I'll see if this provides the information on what I need to move these manually.
April 9, 2013 at 1:26 pm
I'd also suggest following best practice and using different domain accounts for each sql server instance at a minimum. I use different accounts for each service (sql server, sql...
April 4, 2013 at 1:32 pm
Evidently it's a limitation of the SAM Account Name attribute in order to be backwards compatible with older clients - http://msdn.microsoft.com/en-us/library/ms679635.aspx.
April 3, 2013 at 2:47 am
wolfkillj (3/21/2013)
Could you post actual execution plans for both queries - with and without the ROW_NUMBER() function call?
Wolf, I will do that with the other examples. I guess another...
March 21, 2013 at 1:36 pm
@matt-2 & Sergiy - I'll have to repost a better example. I think the point was missed. The predicate applied by the WHERE clause is not...
March 21, 2013 at 1:00 pm
Eugene Elutin (3/20/2013)
tafountain (3/20/2013)
As far as the NEWSEQUENTIALID goes, SSCrazy hit most of the points I didn't elaborate on. ...
Who are you calling SSCrazy, SSC Journeyman? 😉
GUID's are evil! B-r-r-r-r-r!...
March 21, 2013 at 12:54 pm
Viewing 15 posts - 1 through 15 (of 43 total)