Viewing 15 posts - 496 through 510 (of 7,631 total)
CirquedeSQLeil (4/14/2010)
Tom Brown (4/14/2010)
MendelssohnBach
"I'll be Bach."
[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]
April 14, 2010 at 9:38 pm
mishaluba (4/14/2010)
The article is great and the pictures made it so much better! Other columnists should try to adapt this approach too!
The problem with the articles here at SSC,...
[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]
April 14, 2010 at 9:11 pm
Tom.Thomson (4/14/2010)
RBarryYoung (6/15/2009)
GilaMonster (6/15/2009)...No one I've spoken with knows exactly where the estimate is coming from. It's not the 30% of the table that's used with inequalities when a estimate...
[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]
April 14, 2010 at 9:03 pm
I suspect that Steve would like to host one in the future, and as the Host supplies the Topic, he is just soliciting suggestions for a good topic. I...
[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]
April 14, 2010 at 5:49 am
CirquedeSQLeil (4/13/2010)
¿++
++
SFOp
There's no call for that kind of language, Jason. 😛
[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]
April 13, 2010 at 5:51 pm
Glad we could help.
[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]
April 13, 2010 at 4:33 pm
RBarryYoung (4/13/2010)
Roy Ernest (4/13/2010)
That someone has a Black belt... Watch out... :hehe:Yeah, but I have mad Ninja skills... they'll never see me coming ...:cool:
Fyi: NINJA = No Income,...
[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]
April 13, 2010 at 2:18 pm
Roy Ernest (4/13/2010)
That someone has a Black belt... Watch out... :hehe:
Yeah, but I have mad Ninja skills... they'll never see me coming ...:cool:
[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]
April 13, 2010 at 2:15 pm
korolana (4/13/2010)
From the performance point of view I don't think that calling UDTF on every row of...
[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]
April 13, 2010 at 2:11 pm
ChrisM@home (4/13/2010)
Jabberwocky.Had to look up coolats, which are known as culottes here. They're revolting, talk about the worst of both worlds!
Gödellian too. Meh. Must read more.
Yes, they're notorious. 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]
April 13, 2010 at 2:03 pm
This should do it:
;WITH ctePatterns AS
(
SELECT ProjectName as Pattern
FROM #myTableOfProjectsByName
UNION --note: if you...
[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]
April 13, 2010 at 1:59 pm
Toby White (4/13/2010)
Why do you think that Linked Servers are any less secure than Replication or OpenRowset?
Replication is more secure because it is managed, automated, and you can use...
[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]
April 13, 2010 at 1:17 pm
TheSQLGuru (4/13/2010)
RBarryYoung (4/13/2010)
TheSQLGuru (4/13/2010)
RBarryYoung (4/13/2010)
TheSQLGuru (4/13/2010)
[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]
April 13, 2010 at 12:52 pm
Can you post query plans that we can look at (actuals in *.sqlplan preferred)? There probably a statistics/rowcount difference that is leading it astray.
[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]
April 13, 2010 at 12:20 pm
Roy Ernest (4/13/2010)
RBarryYoung (4/13/2010)
Yikes!!! (Exit, stage left ... ) :w00t:You know something? I had the feeling that Gail would see your post ... 🙂
Yeah, I also have a feeling...
[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]
April 13, 2010 at 12:06 pm
Viewing 15 posts - 496 through 510 (of 7,631 total)