I think another tool is the system views,tables and functions. The DMVs in 2005 and beyond can prove quite useful and can provide similar information to PerfMon.

GSquared (3/9/2010)

---

GilaMonster (3/8/2010)

---

I 'complained' about people repeating my posts word...

Remarkable.

I think you missed the point.

If the jobs are going from the US to India, then why move away from the jobs? If you are in India and all...

You're welcome.

Twiggy

WayneS (3/8/2010)

---

luissantos (3/8/2010)

---

If i write like this :

select conta, left(dcli.oldesc,charindex('-',dcli.oldesc)-1),dcli.oldesc,

ltrim(rtrim(conta))+' '+right(ltrim(rtrim(dcli.oldesc)),

len(ltrim(rtrim(dcli.oldesc)))-(charindex('-',dcli.oldesc)-1)),

* from dcli where conta <> left(dcli.oldesc,charindex('-',dcli.oldesc)-1)

I receive the following error:

Msg 536, Level 16, State 5, Line 2

Invalid...

timeouted (3/9/2010)

---

I registered before Jan 15th in order to get the 50% discount from PASS but I didn't have the code at that time.

I really tried to search for it,...

Looking forward to the evening.

Giveaway List (besides the obvious books, cds, dvds, and flash drives)

Mice

SUDOKU Cube

Rubiks Cube

Kilt

Pork Chop Bear (Anti-RBAR logo)

Paul White (3/9/2010)

---

Now you have it! Though, to be fair, that thread is not the best example...not by a long way.

":hehe:" really grates on...

Maybe this is a bit nitpicky, but the answer explanation doesn't seem to match the answer.

This sentence does not match the correct answers....

Thanks for posting back with your solution.

Paul White (3/8/2010)

---

It's not that I mind people having a go - that's great! It just irks me when the post sounds so authoritative, when it is clearly a...

Paul White (3/8/2010)

---

Lynn Pettis (3/8/2010)

---

Yes, I have. I just hope I haven't been a party to...

Lynn Pettis (3/8/2010)

---

I got a call from an employer from which I was fired. They paid me $100 per hour, including travel time (3 hours), to come up and...