First, don't reboot the server or restart the SQL Server service, because you can loose valuable audit information doing that.

You can query sys.objects and order by modify_date desc, create_date desc...

Eric M Russell (4/2/2014)

---

Given the requirements, I don't think there is anything functionally wrong with the table and trigger as is, except that the QuestionID needs to be indexed and...

Given the requirements, I don't think there is anything functionally wrong with the table and trigger as is, except that the QuestionID needs to be indexed and the primary key....

It's unclear from the reqirements whether updating [IsApproved] column should set [datechanged], or if this should only apply to [QuestionTitle].

This article describes a couple of methods to monitor blocking, but keep in mind that blocking is a normal function of isolation and locking, and you should really only be...

I was reading it, thinking what a terrible idea it was, feeling confused about how I had missed rumors of it's potential existence, hoping that it was turned off by...

This is another one of those topics I'll have to unsubscribe from to prevent my inbox from filling up.

Having lived in a nation that doesn't recognize a fundamental human Right To Internet, I was still using dial-up and DSL long after most people had access to cable and...

GoofyGuy (3/31/2014)

---

Eric M Russell wrote:

I actually think that Information Technology, especially on the application development / database administration end of the spectrum, is a relatively easy field to break into...

GoofyGuy (3/31/2014)

---

I wonder if we might encourage people to enter technology professions, not on the basis of their race or gender, but on the basis of their socioeconomic status?

Race and...

SQLRNNR (3/31/2014)

---

I would do the same....

If one of my daughters expressed a desire to pursue a career in technology, I would encourage her with no reservations. Women In Technology meetings sound good as a once...

Whenever an organization needs to build the next version of the platform or leverage some new technology, executive management complains that there is a shortage of software or database engineers....

The problem with restoring from a snapshot or transaction log backup is that you may end up "throwing out the baby with the bath water", meaning that legitimate changes made...

Tail