jswong05 (1/3/2012)

---

Kalen Delaney has a chart in her book "SQL Server 2008 Internals" that shows the difference of isolation level. I will prefer use of snapshot isolation vs read_committed_snapshot isolation.

On...

Michael Valentine Jones (1/3/2012)

---

SQL Kiwi (1/3/2012)

---

Michael Valentine Jones (12/29/2011)

---

This code shows a simple way to eliminate those problems using a rowversion column in the table to make sure it has...

Two DEC(35,20) multiplied gives a result of (71,40). ...

L' Eomot Inversé (1/3/2012)

---

Hugo Kornelis (1/3/2012)

---

Sometimes, I have an idea stuck in my head so tightly that I fail to open my mind to other possibilities. Today was such a...

:laugh: You're welcome!

L' Eomot Inversé (1/3/2012)

---

It is a good question. Nicely shoots down the myth that these fixed point "exact" numerics have fewer (or less serious) rounding issues than floating point...

Dev (1/3/2012)

---

The problem I see here is, there are two groups of MVPs supporting different opinions (On/Off). It’s very difficult for novices (like me) to choose one. One...

Which exact versions of SQL Server are you running, and are you...

Thanks, that's very helpful. As Chris noted earlier, the [LNK_CreatedBy_ID] column is defined as [numeric](18, 0) NOT NULL, but the procedure contains CONVERT(datetime,E.[b]LNK_CreatedBy_ID[/b],103) as [LNK_CreatedBy_ID]. Are you intending...

Gianluca Sartori (1/3/2012)

---

Very popular in Oracle too (SELECT ... FOR UPDATE). Sometimes Often devs do this in PL/SQL code used in forms and hold the lock until the form gets...

No worries Hugo, though I am a little depressed that the values I chose don't make the difference easier to spot - it really wasn't my intention for this question...

Some good points, and it is true...

Michael Valentine Jones (12/29/2011)

---

This code shows a simple way to eliminate those problems using a rowversion column in the table to make sure it has not changed since it was...

David Moutray (12/27/2011)

---

1. Do you know of any good articles that describe the benefits of READ_COMMITTED_SNAPSHOT to a relatively non-technical audience? (It might be more accurate to say that...

Ok so it's not that then. Have a look at the code lines Chris...