Viewing 15 posts - 1,831 through 1,845 (of 7,631 total)
How do you know it isn't enabled. Lots of SQL 2005 features use Service Broker under the hood.
[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 31, 2009 at 5:57 pm
I think that it gets closed when the Target closes it, but I am not sure. Why not just test it and let us know?
[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 31, 2009 at 5:55 pm
oops, I think I misread the question. :blush:
[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 31, 2009 at 5:50 pm
Excellent choice. I wish more people who ask that question had your good sense. 🙂
[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 31, 2009 at 5:30 pm
I've always had the impression that Triggers had more overhead and would be slower than stored procedures. Of course, depending on how long this Excel File work takes, 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 31, 2009 at 5:27 pm
The only way that I know to do it would be to modify the stored procedure to either 1) use the SET ROWCOUNT command (deprecated, I think), or 2) 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]
July 31, 2009 at 11:17 am
It just leaves the conversation open, which in theory can be used by other senders (if they know the conversation handle).
The only bad things, AFAIK is that if you are...
[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 31, 2009 at 10:53 am
Jeff Moden (7/30/2009)
It probably won't do the world any good at all, but I feel MUCH better now...http://www.sqlservercentral.com/Forums/Topic762623-146-1.aspx
Is it just me? Or is this just some cultural thing? ...
[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 31, 2009 at 6:25 am
Duplicate post. Please do not cross post.
Direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx
[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 30, 2009 at 11:39 pm
Here's a naive implementation of the Path-Only model with your data that demonstrates it's advantages:
create table Binary_tree (PathKey Varchar(30) primary key,[Name] varchar(20),Age int);
INSERT into binary_tree (PathKey, Name, Age)
SELECT '','A',21
UNION SELECT...
[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 30, 2009 at 12:03 pm
Binary trees are also particularily good candidates for the "Path-Only" model.
[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 30, 2009 at 11:45 am
That's because you are executing as stlntdom\jsmith and you have not given 'stlntdom\jsmith' access to go through your linked server.
[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 30, 2009 at 11:37 am
???
Weird. I cannot figure how this would make any difference? Nothing wrong with you code, Lowell, it just shouldn't fix a "non-unique" problem. ...
[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 30, 2009 at 11:32 am
Are you calling any custom assemblies or are you using SQLCLR anywhere?
[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 30, 2009 at 11:17 am
jreece (7/30/2009)
And why is gdiplus even getting loaded??!! It's a graphics device interface and this same error gets thrown when I run from the command line.
You get the same...
[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 30, 2009 at 11:13 am
Viewing 15 posts - 1,831 through 1,845 (of 7,631 total)