I'm not aware of anything like this in 2012. To my knowledge the best you could do is use the resource governor to try to limit the one you don't...

Also check out SQL Cop. I wrote a review of it here[/url].

And the query stats are aggregate only. If the query was called multiple times and only one of them spiked, you won't be able to tell much about the spike.

4gb of memory is really not enough to run that many VMs.

You have two options. 1) Make the VMs part of your existing network. You can add them to your...

Data changes can lead to statistics changes which can cause a recompile. If you have a nightly load or something like that you'll see recompiles. Also, plans can simply age...

Or read the book in my signature.

Optimizing stored procedures is a HUGE topic.

A primary key uniquely identifies a row. Let's say you make a primary key on the alphabet. You can insert a value for 'a', and another for 'b', and one...

One phrase sticks out "Made a copy"

Does that mean you ran "BACKUP DATABASE..." or that you copied files?

Assuming it is a backup, check the header. You might find that there...

Not knowing your exact structure, I'm speculating some here...

There are two kinds of indexes, clustered and non-clusterd. You get one clustered index per table. If you're getting a table scan,...

If you have a unique index, it prevents duplicate data. It doesn't matter if you're updating to duplicate the data or inserting to duplicate the data. You can't have duplicate...

Tech on Tap is a free event, single tracked on one topic, yesterday's was on Virtualization. There were three 90 minute sessions and time for networking and questions in between....

Any other List members going to Tech on Tap today? It's shaping up to be an excellent event.

Really? I thought saying Visual Studio and the compliance checks was a direct answer...

Anyway, SQL Cop is also worth a look. I wrote a review of it here[/url].

Yes, it covers all objects. Same with SQL Search.

I work for Red Gate.

If you're entering into a major redesign of the database where you're going to be making lots...

But, on the question of "Too Many Tables to Join"? No, I don't think 10 is too many tables. I wouldn't even worry about "too many" until I was looking...