Viewing 15 posts - 1,606 through 1,620 (of 7,631 total)
meelan (9/4/2009)
1) What permission set is your assembly installed with?I used EXTERNAL permission in the project. VS 2008
You may need to use the UNSAFE permission set.
2) Why are you using...
[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]
September 5, 2009 at 5:34 pm
Questions:
1) What permission set is your assembly installed with?
2) Why are you using ODBC instead of ADO.NET?
3) Why can't you use a linked server 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]
September 4, 2009 at 9:21 pm
I wanted to answer your question about HierarchyID a little bit more completely.
HiearchyID appears to have a real upper limit of about 8000 levels (and a practical upper limit of...
[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]
September 4, 2009 at 8:02 am
GSquared (9/4/2009)
RBarryYoung (9/4/2009)
Jeff Moden (9/3/2009)
REVERSE? Nah... just wicked dyslexic this time of day. 😛Hmm, for some reason I always thought that that word was spelled "cixelsyd". 😛
Lysdexia 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]
September 4, 2009 at 7:51 am
Jeff Moden (9/3/2009)
REVERSE? Nah... just wicked dyslexic this time of day. 😛
Hmm, for some reason I always thought that that word was spelled "cixelsyd". 😛
[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]
September 4, 2009 at 7:45 am
Fraggle (9/3/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]
September 3, 2009 at 10:15 pm
Jeff Moden (9/3/2009)
....enots ot nrut t'nod I os rorrim a hguorht siht ta gnikool yllautca m'I ...denrawerof neeb d'I 😉
Uhm, OK, I'm going to try to counterspell Zantana here, (rattle...
[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]
September 3, 2009 at 7:19 pm
Fraggle (9/3/2009)
... I would venture another guess that a company like Amway easly has 33,000 levels...
Uh, no, that would be incorrect. I sincerely doubt that AmWay has even 200...
[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]
September 3, 2009 at 5:06 pm
A *much* more efficient data structure would be a "sibling-precedence" type of tree, wherein chains of single-child node levels are actually stored as siblings with some kind of precedence ordering,...
[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]
September 3, 2009 at 2:15 pm
Right. We've actually had this discussion before. I think that the whole structure and are wrong for this.
The "branching level" of a tree is the average...
[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]
September 3, 2009 at 2:11 pm
This is why I say that:
paulj_p4 (9/3/2009)
so...
[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]
September 3, 2009 at 1:18 pm
2) No, the possibilities are too divers. You need to clarify this by showing us what you are really dealing with. For instance: there are *extremely* few legitimate...
[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]
September 3, 2009 at 12:52 pm
1) Nope, not directly.
2) The answer is going to be "it depends", because it depends on your Heiarchies and how your CTE's are setup.
That said, my gut feel is that...
[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]
September 3, 2009 at 12:05 pm
PerfMon has a slew of stuff built-in for SQL Server 2005.
[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]
September 3, 2009 at 11:56 am
I don't think that is what he's asking. This appears to be a multi-tenant shared schema situation, wherein "CompanyID" is the Tenant ID. As such, I believe that...
[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]
September 3, 2009 at 11:52 am
Viewing 15 posts - 1,606 through 1,620 (of 7,631 total)