Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a qualified...

I'm so glad you qualified what covered that much ground. I had a totally different picture in my head at first :sick:

Getting a promotion from this single idea is a tough sell. You better have very strong proof on how it helps the business ($, problems avoided, etc).

Still a good...

SQLRNNR (11/17/2011)

---

Jack Corbett (11/17/2011)

---

To get back to the original question, Jason and Remi :-P.

I think we need more information about what your job duties are supposed to be before anyone...

No there are issues when you have too many (or too few)...

If it's still real urgent and you still can't see it you can use this query (it is what activity monitor runs).

--Borrowed from the activity monitor

SELECT

[Session ID]...

p-nut (11/17/2011)

---

Dev (11/17/2011)

---

Thanks to Sean, Ninja & Brandie for sharing your views here. We always discuss about technology but I believe such discussions are equally important.

I will...

Googlers =>

This solution can be viable on a test or dev server. NOT prod.

SQLRNNR (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

SQLRNNR (11/17/2011)

---

Lowell (11/17/2011)

---

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to...

That would explain the oversized brain! 😀

SQLRNNR (11/17/2011)

---

Lowell (11/17/2011)

---

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where the...

I just don't understand why it is being done like that. Makes no obvious sense.

What's the table definition, what's the purpose of the update?

There's no way to answer that question. There are too many variables than affect the answer.

The real problem with that query is that you don't filter anything, so the...

There's a small overhead just for calling the function.

That being said, if the function simply takes 2 parameters and then return their sum, that function will perform very well.

If you...

P.S. That goes on how they treat their employees as well.

If you see something you don't like being done to them (or even despise), you can be sure that...