I guess it depends on what you want to monitor.

There are lots of products out there that will monitor server memory use for you.

It looks a little too basic for me. I'd be more likely to present on that subject than to be on the receiving end of it.

Edit: Might want to...

The SQL Bible series is what got me started (WAY back when).

What I always recommend is, write down a list of questions you need answered about SQL Server, take the...

You could add a step in between 1 and 2, that sends an e-mail to you.

Roy Ernest (1/20/2011)

---

I am planning to write a controversial Blog regarding NO LOCK. 😀 I think you will broil me over red hot charcoal once I am done with it......

LutzM (1/20/2011)

---

CELKO (1/20/2011)

---

Since a table must have a primary key to a table, I automatically put one in the skeleton schemas I post.

ROW_NUMBER() will, effectively, sort the list, then...

with(nolock)

'nuff said.

Ferguson (1/20/2011)

---

It's...

Here's a description I got for a "DBA" position back when I was job hunting in September:

Must have advanced proficiency and extensive knowledge of web development and design technologies, and...

There are tables in msdb (one of the system databases) that store the backup data. You can query those to find what backup files you need in order to...

Just in case, "LEFT PUTER JOIN" is a typo. Should be "LEFT OUTER JOIN".

Congrats.

GilaMonster (1/19/2011)

---

You get a nice little email from MS on the first day...

"Cost" in query plans is just about the most useless piece of junk information ever created. Really. I'm not exaggerating. Most of the time, it's about as...

It is possible to design a table to do this kind of thing.

What you do is change it something like:

create table HorseSense (

ID int identity primary key,

HorseID int not null...