Viewing 15 posts - 2,041 through 2,055 (of 7,631 total)
TRACEY (6/14/2009)
Cost of Threshold for Parallelism to 75 where did you set this in the GUI..and why 75 how to determine if need to change this?
In SSMS, go to the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 5:59 pm
ALZDBA (6/14/2009)
This is a very cool feature...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 1:39 pm
Florian Reischl (6/14/2009)
Wow! Never saw this syntax. Thanks Barry! 🙂
Thanks, Flo. It's in BOL, but I think that I learned it from Erland's blog.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 1:37 pm
Oh goody, we finally have our very own pet troll! I mean, sure we sort of have one already, but he only comes around once in a while and...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 1:23 pm
FYI, if any of you come across this, I ask for a little bit of slack here, I am going somewhere with this. (Or, alternatively check out the personal...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 1:17 pm
CozyRoc (6/14/2009)
RBarryYoung (6/14/2009)
CozyRoc (6/14/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 1:10 pm
Jeff Moden (6/14/2009)
Steve Jones - Editor (6/14/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:26 pm
Steve Jones - Editor (6/14/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:24 pm
GilaMonster (6/14/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:19 pm
Grant Fritchey (6/14/2009)
Jeff Moden (6/12/2009)
I just saw the PASS session list. Congrats Gail and Grant!!!
Congrats to Gail and thanks.
I've got a spotlight and an alternate in the regular sessions.
It...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:17 pm
No, I should apologize. I use american slang and business jargon too often and I forget that many readers are not familiar with them.
"SOP" stands for "Standard...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:10 pm
CozyRoc (6/14/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 12:03 pm
Jeff Moden (6/14/2009)
RBarryYoung (6/14/2009)
I guess almost everybody knows this trick by now?
Heh... apparently not. The OP didn't and neither did the 30 or so DBA's/Developers that I gave a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 11:56 am
mick miller (6/14/2009)
HelloEXECUTE srvdentw.master.sys.sp_msforeachdb 'PRINT ''?'''
Msg 7411, Level 16, State 1, Line 1
Server 'srvdentw' is not configured for RPC.
Thanks miller
Either turn on RPC, or try it like this:
EXEC ('EXECUTE...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 11:53 am
info (6/14/2009)
To the last poster - XXX denotes a specific part of a car. So I have one table containing reviews for all parts with a table...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 14, 2009 at 11:40 am
Viewing 15 posts - 2,041 through 2,055 (of 7,631 total)