Because we use DBPro (aka DataDude) I do a lot of TSQL programming in Visual Studio. It's not terribly good, but the integration with TFS & DBPro makes it necessary.

You will have to pass them in for a SQL guide.

Here's an example:

EXEC sp_create_plan_guide @name = N'APlanGuide',

@stmt = N'SELECT * FROM [Person].[Address] WHERE [City] = @0',...

You call out of TSQL to WMI process to launch a .NET app... right?

But the constant updates from a single spid that is always connected won't act like a transaction & hold that lock open? Just asking, not arguing.

DonaldW (4/9/2008)

---

Mike Menser (4/9/2008)

---

DonaldW (4/9/2008)

---

It is as far as I'm concerned. If I don't tick people off on a regular...

Our starter questions are:

What's the difference between a clustered & non-clustered index?

What's the difference between blocking & deadlocking?

How do you trap errors in SQL Server 2005?

What does the NOLOCK hint...

But you don't need to read data from that table while it's running do you? It looks like, from what you have, that it's going to lock at least a...

There are two that I've been able to work with well. Idera's SQLScaler and Quest's Benchmark Factory. Either one should be able to do what you need. Although I honestly...

Perks? I thought it was the job definition!

You've got a list of parameters inside the query. You should run your query through sp_get_query_template which will give you the correct output and the list of parameters as it...

At least you asked a nice simple question...

Learn some relational design methods. Make sure you take the time to pick good clustered indexes for your tables. Concentrate on set based...

michaela (4/9/2008)

---

This looks like a bad experience. The trick with using VMs is to treat them - logically speaking - as real machines. Then the next question would be: why...

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...