Viewing 15 posts - 6,406 through 6,420 (of 7,631 total)
Amen to that, Brother.
[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]
July 1, 2008 at 3:30 pm
d_sysuk (7/1/2008)
LEAVES ONLY 1 COPY of ANY DUplicate ROW as wanted !!!
Except that that is NOT what was wanted. What was wanted was:
Eliminate One row...
[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]
July 1, 2008 at 7:38 am
Benny Lopez (6/30/2008)
Is there a SS Managment Studio (workbench) feature that would let me save the output automatically?
Well you can set your results output to "Save to file..", but 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]
July 1, 2008 at 6:23 am
Ah, OK. Now I understand. Thanks,
[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]
July 1, 2008 at 6:06 am
What? You couldn't remember that it goes quote, quote, quote, value one, quote, quote, comma, quote, quote, value two, quote, quote, comma, quote, quote, value three, quote, quote, comma,...
[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]
July 1, 2008 at 6:03 am
But if you want to stay with this, call it like this:
[font="Courier New"]
EXEC sp_Balance_BF '''A1'',''A2'',''A3'',''A4''', '', '', ''[/font]
[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 30, 2008 at 7:14 pm
GSquared (6/30/2008)
[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 30, 2008 at 5:06 pm
Thanks for the feedback, sherjon.
[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 30, 2008 at 4:37 pm
Jeff Moden (6/29/2008)
Similar error as to what someone recently did with dates 😉 Check the final value of @BitBucket on Matt's...
OK, I see. :blush: I really need to take...
[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 30, 2008 at 1:42 pm
ALZDBA (6/30/2008)
Run the same script again in one month.If that results in '%_obsolete_obsolete' tables, that would mean it hasn't been used for a month, so maybe good candidate for cleanup.
Actually,...
[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 30, 2008 at 1:39 pm
I must have been focusing on these two statements:
Ideally, I wanted to find a way to have the caller that needed to run the dynamic SQL be able to catch...
[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 30, 2008 at 1:29 pm
Thanks, folks. I'll try to get it done and in the queue by tonight. I'll be sure to post a link to it from here then.
[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 30, 2008 at 6:30 am
Sergio Seseña (6/29/2008)
I try with my experience to answer which is the more powerful language.
Experience: I have programmed in C# as long as it has existed (about 8 years,...
[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 29, 2008 at 8:14 pm
Jeff Moden (6/29/2008)
Actually, no Order By is really necessary except to satisfy the syntactical requirements of Row_Number()...
Hmmm, ... for some reason I'm not scanning it. But I'll take your...
[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 29, 2008 at 7:34 pm
Jeffrey Williams (6/29/2008)And since TOP in SQL Server 2005 can use an expression, you can get rid of @Days completely.
Yeah, I knew that, but I wanted @Days because it makes...
[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 29, 2008 at 7:24 pm
Viewing 15 posts - 6,406 through 6,420 (of 7,631 total)