Forum Replies Created

Viewing 15 posts - 31 through 45 (of 95 total)

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Two more bits of empirical evidence in favor of having a degree, regardless of what area of study:

    1) I've been told more than once that the fact that my masters...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    I'm a developer/architect rather than a DBA but my bachelors and masters are both in geology & geochemistry. (I had been working toward a CS minor in college, but...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Connection pooling issue from .NET

    Yes, clearly - but I think you're still missing the significance of the issue.

    Since the context is different, you would think it would *create its own connection pool*. ...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Connection pooling issue from .NET

    I actually figured out what was happening by the scientific method, it has nothing to do with Silverlight but does have to do with the service layer and the difference...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Connection pooling issue from .NET

    Interesting. That first link is actually not about SQL connections in WCF but basically creating a pool of connections TO the WCF service, more like a "proxy pool" than...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Connection pooling issue from .NET

    I'm sorry, but I really don't understand what you are trying to say. What do stored procedures have to do with it?

    Since the connection pool is maintained on the...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Connection pooling issue from .NET

    Nope, no transactions in these queries - they are all reads only

    I don't think there would be time yet for objects not to be disposed -this happens as soon as...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Manage Your Career

    Two things -

    Regarding staying current, I agree 100%. I have worked with many "dinosaurs" who call themselves technical but are wholly resistant to change and they are nothing...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Looking for a non-RBAR solution to an update w/ aggregates problem

    Lynn, I started with yours but found I actually had to add the "group by" that Mark had in his since the Table1.ID wasn't part of any aggregate. I...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Looking for a non-RBAR solution to an update w/ aggregates problem

    Thanks again, this idea worked perfectly and gave me ideas for sprucing up some other processes as well. I had used CTEs for paging but not for bulk updates,...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Looking for a non-RBAR solution to an update w/ aggregates problem

    Visually it looks exactly like what I am trying to do, I will try it now.

    Thanks!

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Intermittent connectivity issue - how to diagnose and fix

    Just posting a followup since I've resolved this - it turns out the problem was related to connection pool settings.

    I'm not sure why bad connection pool settings from one app...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Intermittent connectivity issue - how to diagnose and fix

    Well, this morning I did some more testing and this is what I found.

    During the process the CPU on the server is stable at about 15% and drops to almost...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: Intermittent connectivity issue - how to diagnose and fix

    Hmm, I actually use machine name when running against our QA server and IP address on staging, but see the problem occurring in both cases.

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

  • RE: T-Sql rant

    Guys & gals, I think it's time to stop feeding the troll.

    Clearly he is arguing himself into a corner because he can't admit that his original premise was based on...

    --
    Anye Mercy
    "Service Unavailable is not an Error" -- John, ENOM support
    "You keep using that word. I do not think it means what you think it means." -- Inigo Montoya in "Princess Bride"
    "Civilization exists by geologic consent, subject to change without notice." -- Will Durant

Viewing 15 posts - 31 through 45 (of 95 total)