To recap:

1. Profiler filter issue resolved. You see the deadlocks there now.

2. No indexed views

3. Tuning the code is far from feasible currently.

4. Tracking down how the app accesses the...

The beauty of filters with profiler. You already found...

Ed Wagner (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a...

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in...

He shouldn't have unplugged the server so he could plug in his vacuum.

Extended

Hugo Kornelis (9/30/2015)

---

None of these answers are fully correct. To ensure minimal data loss, one should always start by a tail-log backup. (Which will fail if the log file is...

Ed Wagner (9/30/2015)

---

rodjkidd (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Alvin Ramard (9/30/2015)

---

Oh wait! Not all four letter words are bad!

Cold Beer: Two...

https://msdn.microsoft.com/en-us/library/ms178067(v=sql.100).aspx

robinwilson (9/28/2015)

---

To try to make it work (even though I don't agree with no lock) I added no lock throughout and re-wrote it to use only table-valued functions and it...

Here are the max supported configs by edition for SQL Server 2008:

https://msdn.microsoft.com/en-us/library/ms143685(v=sql.100).aspx

Node

If it is gonna be called branching, why couldn't they use grafting in lieu...

Agreed.

Koopa