Great info. If they relaunch the effort I'll definately use this stuff as a reference. Thanks.

It was basically functional. The key issues, apart from deployment issues & some performance, were around how we could manage the virtual versions of AD. It apparently wasn't surmountable.

Yu Yang (4/8/2008)

---

What were the key factors make to choose virtualized OS (VMware) vs. virtualized SQL (instance)? VMware will introduce some perform overhead, as well as extra admin effort. On...

Contrarian...

Goddess bless you. You guys are so entertaining.

Just for the virtualizations. We already do resets from production as a part of our QA testing. We were just hoping to incorporate a similar process into an automated development...

The thing is, I think we could have made it work. But the expectations were so unrealistic that while we had functionality, we didn't have perfection. Sans perfections, they pulled...

Ivanna Noh (4/7/2008)

---

rbarryyoung (4/7/2008)

---

Jeff Moden (4/7/2008)

---

rbarryyoung (4/6/2008)

---

Good one. 🙂

I was serious about my Uncle though, he really did do all...

Hopefully you can post the xml as an attachment like Gail says.

Just looking through the text plan, I see a clustered index scan on PK_MSP_WEB_RESOURCES_WRES_ID which could be a cause...

Profiler output is to a text column, but if you're selecting from a text column in a TSQL Query, you might not be seeing all the data (there's a limit...

I did write a couple of articles on unit testing here at SQL Server Central. Two of them cover DBPro and one covers TSQLUnit. Do a search. There might be...

Most people just insert a row of data into the database, run a select query or a delete query and declare it successful if it finishes without error. For myself,...

You must be experiencing blocking or something else on the server. This query, as you have it defined, takes 1 ms to run on my laptop (not exactly a screaming...

By the way, from what I can see, GetMatricule is going to force the query to function like a cursor, running this select statement for each row in the result...

Please post the execution plan.

Or without anything else, an execution plan will identify the worst bottlenecks. Can you post one?