It's not only important to monitor how long it takes something to run, it's often important to monitor when (if ever) it was run and who ran it.

That way, when...

RalphWilson (8/30/2010)

---

Now that we appear to be including DW in the mix, I have a question for y'all.

Suppose I have a database in which I am storing the answers that...

Eric Russell 13013 (8/30/2010)

---

alen teplitsky (8/30/2010)

---

i've seen this no NULL's allowed OCD thing being taken to extremes

say you sign up a customer today and promise some service that will be...

I don't remember who wrote this comment, but it's the most profound one I've ever come across regarding data quality. I'll paraphrase because I don't remember the exact quote:

"The...

jeff.mason (8/25/2010)

---

Only major issue we've seen is SharePoint -- Polyserve and...

You had it right the first time, I just misread what you told me.

Thanks for taking the time to slap me upside the head and tell me to pay more...

Got excited when a colleague suggested it might be a user-entered filter in SSMS.

Wasn't, but it might be helpful to the next person with this problem...

Sadly, that isn't helping.

Already tried that. 🙁

Removed the user and recreated it. Verified it synchs up with the login.

granted datareader and public, then select and view_definition to some of...

Hi,

We just had the same problem show up today, but with views instead of tables.

Did you ever find a fix?

Many of these systems get into trouble because managers tell IT staffers what they wish would happen instead of what will happen - and IT folks think they are hearing...

He refused to give the passwords to his MANAGER.

A person's MANAGER is, by definition, the person who is the RESPONSIBLE PERSON for the tasks that you do.

In the...

SanDroid (8/18/2010)

---

Lots of feelings spilling out here, but the facts are this:

* The person asking for the passwords to gain control of the Network was not certified or authorized...

He stole a valuable organizational asset.

He caused the organization extensive expenses to correct the problem he caused.

He caused the taxpayers to pay for all of that.

The dumb $hit got what...

Thanks, I'll look into that. It's a new box, the SAs might have forgotten to do that.

John Mitchell-245523 (8/13/2010)

---

David

Databases in Simple recovery mode do have a log file, but you can't back it up since it is automatically truncated by SQL Server on a regular basis....