Viewing 15 posts - 6,391 through 6,405 (of 7,631 total)
heh, That would explain the yellow spots I keep seeing... 😀
😛
[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 4, 2008 at 7:41 am
rbarryyoung (7/3/2008)
As 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 3, 2008 at 9:58 pm
Larry Huisingh (7/3/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]
July 3, 2008 at 8:58 pm
Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).
As for 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]
July 3, 2008 at 8:39 pm
Well, actually, you can do it on the DB side, but it is a lot more trouble than it's worth.
[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 3, 2008 at 3:17 pm
I am doing this right now, but unfortunately, one of the things that I have learned about Service Broker is that it is hard to do anything "simply". 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 3, 2008 at 11:15 am
Jonathan Kehayias (7/3/2008)
http://msdn.microsoft.com/en-us/library/ms190479.aspx
Then a DML Trigger on...
[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 3, 2008 at 9:06 am
Woo-Hoo! Way to go Gail! :w00t:
What an excellent choice by Microsoft. What really strike me about Gail is the incredible precision and accuracy of her responses. Despite 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]
July 3, 2008 at 8:48 am
GilaMonster (7/2/2008)
Jeff Moden (7/2/2008)
Track you down? Heh... I'm putting my Avatar on the back of a couple of shirts so I'll be easy to find. 😛
Not a bad...
[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 3, 2008 at 5:35 am
Dynamic 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 2, 2008 at 8:42 pm
Or just make it. [font="courier"]is_active (bit)[/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]
July 2, 2008 at 8:28 pm
There are several ways to do this, SQL CLR routines are probably one of the less advantageous ways.
Other ways:
1) SQL Replication
2) Triggers and Linked-Servers
3) Service Broker & EndPoints
[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 2, 2008 at 8:23 pm
Jeff Moden (7/2/2008)
ALZDBA (7/2/2008)
Congratulations Jeff and Michael.A virtual pint to your honor ! (maybe we'll materialize that at SQLPass 😀 )
We can do that! I'll actually be at PASS...
[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 2, 2008 at 6:08 pm
Congratulations Jeff & Michael! Richly-deserved...
[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 2, 2008 at 11:24 am
Chris Morris (7/1/2008)
DECLARE @ItemID INT
DECLARE @FirstCol varChar(5), @SecondCol INT, @ThirdCol Char(1)
SET @ItemID = 1
UPDATE #Testing SET ThirdCol = CASE @ItemID WHEN 1...
[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 4:33 pm
Viewing 15 posts - 6,391 through 6,405 (of 7,631 total)