Viewing 15 posts - 1,906 through 1,920 (of 7,631 total)
Gaby Abed (7/9/2009)
Alvin Ramard (7/9/2009)
Does anyone know why "abbreviated" is such a long word?🙂
For the same reason "long" is such a short word? 🙂
English is a funny language. For...
[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 10, 2009 at 11:14 pm
Gaby Abed (7/9/2009)
Jan Van der Eecken (7/9/2009)
Paul White (7/8/2009)
Jan Van der Eecken (7/8/2009)
DonaudampfschifffahrtsgesellschaftskapitaenskajuetenschluessellochThe keyhole in the door of the Danube steamship company's captain's cabin. :w00t:
10 out of 10 for this...
[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 10, 2009 at 11:07 pm
arthykannan (7/6/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]
July 10, 2009 at 8:46 pm
GSquared (7/6/2009)
RBarryYoung (7/3/2009)
RBarryYoung (7/3/2009)
And most of all, that people would say, or describe themselves as doing, something obnoxious or offensive and when they got called on it instead of admitting...
[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 6, 2009 at 11:03 am
OK, I assume that you do not want/need either the service or the queue, right? They're just a leftover from the demo install?
If so, then proceed as follows:
1) DROP...
[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 6, 2009 at 10:56 am
You just specify them. The problem with optional parameters in User Defined Functions is that you can't not specify them: so they are not really "optional".
[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 6, 2009 at 8:01 am
Yep, an INSERT..SELECT. Try it like this:
INSERT Into ccc(caa, cbb)
SELECT aa, bb
FROM bb
I think you'll agree, that's a bit easier. And it's loads faster.
[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 6, 2009 at 7:26 am
Of course I'm going on Vacation in the morning... So, you want to look for things like adding string literals onto the front of your NVarchar(MAX):
SELECT @BigStr...
[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 6, 2009 at 12:25 am
WayneS (7/5/2009)
Ghanta (7/5/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]
July 6, 2009 at 12:14 am
Thing is, I'm not sure that its true about sp_ExecuteSql either. Here's a script that demonstrates both successfully executing a string WAY over 4000 characters:
Declare @sql as nvarchar(MAX)
set @sql...
[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 5, 2009 at 9:26 pm
Ghanta (7/5/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]
July 5, 2009 at 9:12 pm
Lowell (7/5/2009)
...EXEC is a command, and has no parameters.. just tries to execute whatever you pass it. So when you pass it a (max), it gets truncated.
??? I'm sure...
[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 5, 2009 at 9:00 pm
Jeff Moden (7/5/2009)
Digs (7/5/2009)
Thanks all sorted now !This code is for an ASP.net project, data input comes from 3 textboxes that will out put a string each.
Ok... first, it's 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]
July 5, 2009 at 8:54 pm
matthewspare (7/5/2009)
...How do I programmatically insert records from the Orig Production table into the New Production table (with the new columns)
You want to use SELECT INTO for this, as 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]
July 5, 2009 at 7:42 pm
Some aspects of this a relatively easy. But other aspects are really hard. And the hardest part is being sure that you haven't actually missed anything because there...
[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 5, 2009 at 7:32 pm
Viewing 15 posts - 1,906 through 1,920 (of 7,631 total)