I think it is a good approach.

Make sure you tidy up the code a little (your drop table is attempting to drop ##DBUSER which is not the table you created).

Lynn Pettis (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

jcrawf02 (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

Grant Fritchey (2/19/2010)

---

If you haven't submitted anything to Tony Davis at Simple-Talk, head on over there. His editing process can feel a bit like a...

jcrawf02 (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

Grant Fritchey (2/19/2010)

---

If you haven't submitted anything to Tony Davis at Simple-Talk, head on over there. His editing process can feel a bit like a prison rape, but...

Grant Fritchey (2/19/2010)

---

If you haven't submitted anything to Tony Davis at Simple-Talk, head on over there. His editing process can feel a bit like a prison rape, but you'll really...

Grant Fritchey (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

Thanks for both the affirmation of fears on the topic as...

We were permitted maintenance windows once per month for 8hrs. This was limited to global access and online presence. Getting anything more than that required business and client...

Let us know how that goes.

Thanks for both the affirmation of fears on the topic as well as path...

Wow - that was a quick turnaround.

Nice article Wayne.

corpuscle

isuckatsql (2/19/2010)

---

I got perfmon running and did a test on my 60 GB DB accessing 2.25 Million records.

During a 2 minute test, it accessed approx 155 000 records, results...

Lynn Pettis (2/19/2010)

---

CirquedeSQLeil (2/19/2010)

---

Lynn Pettis (2/19/2010)

---

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one....

Alvin Ramard (2/19/2010)

---

Lynn Pettis (2/19/2010)

---

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. ...

Lynn Pettis (2/19/2010)

---

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. BTW -...