Great article!  As one of the "support people have to pick up bugs in live code," we tend to be quick to blame the developers without considering their world.  Most...

Just an update....

SELECT
@checkpoint_id = MAX(checkpoint_id)
FROM ssf_widget_checkpoint WITH (NOLOCK)


So this is the primary issue. Ironically, we...

bmg002 nailed it!  99% of the naming conventions and code are from the software vendor.  Did you ever hear the phrase "..changing a horse midstream?" If I ended up going to...

"Without HOLDING A LOCK on that table when you get the MAX (until you do your subsequent INSERT) means any other process (those constant UPDATE/INSERTs) can create a duplicate key."

Thank you for the response.  I do appreciate it!  Just to give my pointless replies. 🙂

1)Dirty reading is fine in this instance.  The data being read will not...

Great article/script and VERY eye-opening!! I'm not part of our company's DBA team, but I have a few sandboxes to play in. Just running it in our test...

It's taken us about 5 years, but we are 99% to an Active Directory Group solution. It has made life much easier for our DBA team and to pass...

I am not a developer. However, as most of us SQL-ers do, I often have to modify or create code to work through and issue or project. It...

Pretty neat! Thank you sir.

Great article Steve! I am neither an "official" DBA nor developer. However, I work with the database all day, every day on the operations and projects sides. ...

It WAS easy. Yes, I missed it as well. Sometimes we look for the difficulty in a problem, we miss the easy solution. Point well made, indeed....

Arrrrggghhh! If only I had this article a few weeks ago. Great job! I do appreciate the detailed trouble-shooting explanations...our whole team does!

Terry300577 (12/20/2012)

---

TriggerMan (12/20/2012)

---

These questions really are like individuals' SQL scripting styles... there are always 50 perspectives... I give you from BOL from SQL 2008 Express R2 (which many of...

+1