SSDs are relatively cheap today, so why not include them in the analysis? They perform excellent as well.

1. If you can allow the shrink operation then you can shrink the data file and after rebuild the indexes, because the shrink will introduce a lot of fragmentation.

2....

I agree. Even if...

Good to know that group by lumps the nulls.

Thanks

This is something that I noticed some period ago, and it's definitely a good idea - a filter for the columns to be implemented in ssms.

Sometimes I use the red-gate...

+1

Great question. Could have considered the above in order to get the question right.

GilaMonster (12/31/2014)

---

Which means you no longer have atomicity...

Thanks to all in this discussion.

I had 4 update statements (2 updates and 2 merges ) in one transaction and I isolated them in separate transactions.

On the update statements i...

GilaMonster (12/30/2014)

---

Igor Micev (12/30/2014)

---

Hi Gail,

I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't...

Hi Gail,

I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't you do that...

GilaMonster (12/29/2014)

---

Yes, and?

I've read that read committed snapshot uses pessimistic writes, and snapshot...

Igor Micev (12/29/2014)

---

GilaMonster (12/29/2014)

---

Depends. If you explicitly request an isolation level, you get whichever one you request. If you allow the default of read committed, then you get read committed...

GilaMonster (12/29/2014)

---

Depends. If you explicitly request an isolation level, you get whichever one you request. If you allow the default of read committed, then you get read committed using row...

GilaMonster (12/29/2014)

---

Read committed snapshot is the read committed isolation level, implemented with row versions. It's not a separate isolation level like Snapshot is.

Hence you see Read Committed as the isolation...

Thanks both for the replies

from the deadlock report you can see isolationlevel = "read committed (2)"

Isolation level for all databases is READ COMMITTED SNAPSHOT, and that is one of...