I was going to suggest subtracting five hours from the time to get the appropriate date, but I see that Michael beat me to it.

The thing to keep in mind...

Silverfox (9/7/2009)

---

Just out of curiosity, Am I the only DBA that doesnt have a laptop or a desktop and no sql books, who didnt go to university :-D, doesnt have...

I think a tech interview over the phone is fine. That's just testing what you know. Personality through the phone? I doubt that's useful. 90% of...

The output clause is definitely one of the best new features in 2005.

Like others have already posted, I'd output into a temp table (or table variable), and then use that...

I have to admit, I don't test drivers on my computers to see which is "best". I download the most current, and if it becomes unstable, I revert to...

GSquared (9/4/2009)

---

Is there a reason to denormalize it that way, and not just sum up the counties when you need the state total? If that won't work (for performance...

This is a duplicate thread. Discussion is already underway in the other forum it was posted in.

t_marciniszyn, please don't double-post.

As far as falsifying credentials goes, I'm pretty sure you could get away with using "setuser" for that more easily than you can pull a password out of RAM anyway.

Unfortunately, and unintuitively, you have to save each section of the plan. All those files have is the initial variable assignment.

You're welcome.

The sequence of the inserts won't matter. If there's a duplicate value, there's a duplicate value. That's all that matters here.

Is there a reason to denormalize it that way, and not just sum up the counties when you need the state total? If that won't work (for performance reasons),...

If there's already a row that's got 10 in the PK column, you can't insert another one with the same value. Primary Keys don't allow duplicate values.

Daniel C (9/4/2009)

---

Also a question about this trigger. Is it acting like an AFTER trigger, generating an additional IO for each DML or is it doing the changes in the...

The main objection to any trigger is that it's hidden from the developers. A more standard way to update that column would be to make sure the update proc...