mah_j (10/23/2016)

---

Currently the index is just on invoiceuid,but because of lookup I test it with other columns too.But for both modes the logical io is high.

GilaMonster (10/22/2016)

---

Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.

Eirikur Eiriksson (10/18/2016)

---

Just had a Blast from the past

😎

GilaMonster (10/22/2016)

---

Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.

mah_j (10/22/2016)

---

Hello

How can I stop the long running query that is run from application?

I want to kill the queries that are running longer than 40 seconds.

Eirikur Eiriksson (10/18/2016)

---

Just had a Blast from the past

😎

Stuart Davies (10/19/2016)

---

Ed Wagner (10/18/2016)

---

Ray K (10/18/2016)

---

djj (10/18/2016)

---

ZZartin (10/18/2016)

---

Luis Cazares (10/18/2016)

---

Manic Star (10/18/2016)

---

djj (10/18/2016)

---

Ed Wagner (10/18/2016)

---

whereisSQL? (10/18/2016)

---

Revenant (10/18/2016)

---

crookj (10/18/2016)

---

djj (10/18/2016)

---

Grumpy DBA (10/18/2016)

---

BWFC (10/18/2016)

---

Current

Currant

Food

Hungry

Hungary

Europe

Brexit

Vote

Drink

Martini

Dirty

Clean

Mr.

Anderson

Tapes

Eirikur Eiriksson (10/13/2016)

---

Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.