GSquared, so in your understanding specifying transaction isolation level of Serializable when the database is Read Committed Snapshot and the application is expecting Read Committed Snapshot would almost certainly lead...

And thanks!:-D

Now, for an immediate workaround, build yourself a non-clustered index containing just the VARCHAR(20) lookup and include the ID that you're trying to return. Even if it copies the leading...

Strange, it's not scrolling on my Chrome browser. But...

GilaMonster (12/29/2011)

---

That 35% fragmentation is in a non-leaf level of your index, a level that has much fewer pages than the leaf and will be much less affected by fragmentation...

Appreciate that tip. You know how it goes though, you're investigating a problem and you...

GSquared (12/29/2011)

---

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should support....

No, I'm not trying to get to 0% as that's typically not attainable.

[font="Courier New"]Table: 'CONSUMERS' (645577338); index ID: 1, database ID: 5

TABLE level scan performed.

- Extent Scan Fragmentation ...................: 23.76%

TableName...

Do you have a test system where you can try out RCSI?

I have past experience with legacy DWH where reports would write to persistant tables before pulling those results out...

I was running into the same issue, yet the issue only manifested when multiple rows were updated. All of the updated rows had a column that was being manipulated all...