That's a neat approach and one I've...

Sean Lange (9/1/2015)

---

Ed Wagner (9/1/2015)

---

Alvin Ramard (9/1/2015)

---

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't...

DonlSimpson (9/1/2015)

---

Ed Wagner (9/1/2015)

---

whereisSQL? (9/1/2015)

---

crookj (9/1/2015)

---

Revenant (8/31/2015)

---

Ed Wagner (8/31/2015)

---

Revenant (8/31/2015)

---

ZZartin (8/31/2015)

---

whereisSQL? (8/31/2015)

---

DonlSimpson (8/31/2015)

---

Ed Wagner (8/31/2015)

---

Luis Cazares (8/31/2015)

---

whereisSQL? (8/31/2015)

---

djj (8/31/2015)

---

Ed Wagner (8/28/2015)

---

whereisSQL? (8/28/2015)

---

Luis Cazares (8/28/2015)

---

Ed Wagner (8/28/2015)

---

White...

Finding performance problems can be difficult. Fixing them can be difficult. However, it doesn't usually matter how hard it is to find or fix problematic procedures - it...

Alvin Ramard (9/1/2015)

---

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to have to...

Lynn Pettis (9/1/2015)

---

Silver spoon, you are in the wrong business.

Let's comment out the COMMIT and ROLLBACK statements in code during testing because I don't want to have to restore the...

Lynn Pettis (9/1/2015)

---

Welsh Corgi (9/1/2015)

---

Eric M Russell (8/31/2015)

---

Welsh Corgi (8/31/2015)

---

Eric M Russell (8/31/2015)

---

TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this,...

Pooh Bear

I think a part of the problem with software estimating versus the construction industry is that in construction, the customer can physically see the progress that's been made. If,...

Great question. I love the system catalog and DMVs.

From the OP, it looks like John hit the nail on the head, but if your requirements are different, please let us know.

One thing I feel necessary to point out...

You define a connection and execute a query. What's returned from your query...

jasona.work (8/31/2015)

---

Jeff Moden (8/31/2015)

---

Steve Jones - SSC Editor (8/31/2015)

---

I'm not sure this is as big a deal as some people have written. Hard to decide if this is journalism run...

Coffee

Roast