Viewing 15 posts - 4,351 through 4,365 (of 7,631 total)
IMHO SQLCLR only outperforms T-SQL in two general cases:
1) In cases where the same activation path must be followed by both (Triggers, Service Broker activation procs) then CLR appears...
[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]
December 19, 2008 at 6:58 am
If you are using SSMS, then there are query options that limit the size of the text that it will display. The options are under Query Reusts..Text, and ..Grid.
[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]
December 19, 2008 at 6:39 am
ALZDBA (12/19/2008)
begin tran ... commit tranJust encapsulating the trigger with its own Begin tran ... commit tran, off course didn't do the trick.
Because: that tran is...
[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]
December 19, 2008 at 6:35 am
Well if the colon (":") doesn't work, then I would try it with a comma (",") instead. 🙂
[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]
December 18, 2008 at 12:42 pm
This article by Frédéric BROUARD gives the best explanation that I know of for the Nested Sets model: http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/
[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]
December 18, 2008 at 8:42 am
The Path model is the original unadorned natural model of a Tree or a tree-based hierarchy. To use the analogy of our C: drive's filesystem The path mode...
[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]
December 18, 2008 at 8:35 am
Try it like this in your connection string "111.222.333.444:1433"
[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]
December 17, 2008 at 10:28 pm
GilaMonster (12/17/2008)
Forum Newbie - 0
Grasshopper - 10
SSC Rookie...
[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]
December 17, 2008 at 7:52 pm
gcopeland (12/17/2008)
I wish these were online somewhere, or even better if the point value would pop up in a tooltip when you hover over the value.
Well they are online, in...
[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]
December 17, 2008 at 7:51 pm
This is a duplicate post. Please do not cross-post.
Please direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic621734-148-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]
December 17, 2008 at 7:44 pm
"formula" is not a SQL Server term.
Do you possibly mean a user-defined Function?
[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]
December 17, 2008 at 7:41 pm
Heh. Well, glad I could help, though it seems like you were able to do that without me. 🙂
[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]
December 17, 2008 at 4:58 pm
Chad Crawford (12/17/2008)
If you don't mind, help me understand the advantage of having it stored in a binary format, but converted for readability.
I think that you've got it later 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]
December 17, 2008 at 4:38 pm
Jeff Moden (12/17/2008)
Also, have you given any thought to using a hybrid of the Nested Set Model instead of the Adjacency Model you're currently using?
Actually, Jeff, I believe that 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]
December 17, 2008 at 4:16 pm
maddogs (12/17/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]
December 17, 2008 at 4:10 pm
Viewing 15 posts - 4,351 through 4,365 (of 7,631 total)