We have this automated all over the place. You need to script out a few sets of processes. First, obviously, the database restore. Then, you need to remove production level...

Just remember that the DMV referenced above, while an excellent approach to finding the offending query, is dependent on that query being in cache. If you want to be sure...

aspardeshi (10/15/2010)

---

Hi Gila,

Thanks for the update. I will give you sufficient reasoning below the logic, the logic is that every student need not register parent user id, but every parent...

That is a huge topic. You're not likely to get really useful responses in a forum like this. The configuration you need to put on your system is very dependent...

Best way to avoid this that I know of, two logins. Have a special login for going to the production system. Then, you have to do a Run As in...

nick.mcdermaid (10/14/2010)

---

If you search on a covered non-clustered index on a table with a clustered index, you get a bookmark lookup where the index goes and looks up the row...

I haven't used it, but I did an eval of PowerDesigner. It's a very good piece of software, especially if you have...

A trace might work and it might not. If the queries are calling for tables that don't exist, or columns within tables that don't exist, or the data types are...

Have you explored the option of using Replication? It's set up to do a lot of what you just outlined. I'd try that as a first choice.

I would only model in Visio if someone held a gun to my head. But if it's unclear where I stand, let me know and I'll try to be less...

Steve Jones - SSC Editor (10/14/2010)

---

jcrawf02 (10/14/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

Doesn't bode well for lots of jobs, and I hope that some level of "bookstore" still remains in the...

CirquedeSQLeil (10/14/2010)

---

Grant Fritchey (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

They have color e-ink now, it just isn't in commercial devices yet. There was a Sci-Am article about it a year...

Rob Schripsema (10/14/2010)

---

Grant,

Thanks for the reply. Sounds like there isn't complete consensus on whether GUIDs are valid for clustered indexes or not. So far, we've not seen significant performance impact...

Dave Ballantyne (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

They have color e-ink now, it just isn't in commercial devices yet. There was a Sci-Am article about it a year or...

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Neato!...