I suspect slowness now is the synchronous call to the Askimet app on posting. I've asked if we can change this to a background thread that looks for changes in...

aochss (10/15/2014)

---

I gauge the success and satisfaction of the programs I work based on the following:

- Have my changes made life easier for the end users of the...

Noooooooooooooooooooooooooooooooooooo (screaming, shakes head, angry face).

We do not grant rights for users. Only roles. Use roles. Please. Roles.

Pretty please.

And the Gui is a mess. Use it if you must, but...

Not transactional replication? If you snapshot entire tables, that could be a lot of data, depending.

Do you need stable reporting throughout the day, or more up to date date.

Enterprise Edition...

Probably somewhere that is giving you bad plans or sniffing, and you want to freeze things when you get...

Good luck, on both projects.

And you're welcome.

Don't use NOLOCK

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/

Not to get political (too much), but I tend to agree with Eric, mostly. Government often makes big projects, which is a bit of a function of how things are...

If that's the case, trigger.

Simple. Make it row based, and you can use Merge, but I'd just do.

create trigger

update LastTime set time = i.time

from inserted

where i.event = lasttime.event

Note...

Today was a day when they released a lot of Connect items as won't fix, or for things like my doc bugs, fixed.

Lynn Pettis (10/14/2014)

---

Steve Jones - SSC Editor (10/14/2014)

---

Unbelievable. Giants can't score, not even a FG, SD decides not to play defense against the Raiders, and Manning has a pedestrian day,...

Congrats, Grant

Luis Cazares (10/14/2014)

---

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen a code...

Unbelievable. Giants can't score, not even a FG, SD decides not to play defense against the Raiders, and Manning has a pedestrian day, ignoring Sanders for the most part.

(shakes head)

OK, I'm still slightly confused, but I think you mean you have a source where you have everything, all records. However you only want the latest time for an event...