davas (9/14/2011)

---

Thanks for that. The other SQL server i am thinking of belongs to a sister company running similar tools and processes to our own. I'd like to see if...

Do you take full backups of your important dbs?

Do you NOT clear the backup history table?

If so I have a script that does that for ya.

sushila (9/14/2011)

---

Tsk tsk Remi - in a hurry to type eh - it's good old days (plural)...

Your reasoning is correct, however without the perfom context (like cpu %, ram, etc) you can't really make that call.

I see where you'd be going with this in a consolidation...

Ah the good old day, when techers didn't know about...

HowardW (9/14/2011)

---

Being a bit pedantic, but I've read that article before and some of the arguments against also apply to the default READ COMMITTED isolation level. In either case you...

Counters by themselves are useless.

You need to compare them to a baseline.

This is probably closer to what you need : http://www.red-gate.com/products/dba/sql-monitor

I'm sure you had it coming,...

That's precisely why I don't share this code (too much).

It can lead to the wrong conclusion and fix symptoms rather than cause. CXpacket is not a problem per se....

Cadavre (9/14/2011)

---

My advice will be unpopular, but I struggled to find my first development position so started off working for free at an NHS business intelligence solutions provider.

I had some...

I keep getting mail notifications "Jeff Moden elected ..."

and I kep hearing "elected for president".

Maybe that's the next logical step :-D.

Ya just get your name out there (recruiters, linkedin, monsters, firms, craiglist, etc).

At the worst you'd at least get small temp contracts and keep having a decent income.

I'm on just...

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

As I said, good argument to look at an upgrade... maybe wait 'till denali (you can always only upgrade the ssrs side of things which makes the upgrade easier...

No jobs in healtcare NOR erp?

I find that a little hard to believe.

Anywho, when you see a job with 1 gazillion years of experience required you can still apply. ...