Of course, once again...it depends.

Studies performed by VMware have shown that SQL performs from 88 to 99 percent as fast as physical under virtualization, provided that the host has CPUs...

Hmmm....Try this

Create table #foo (col1 int null, col2 int null)

insert #foo

select NULL,1 union select 1,NULL

select COUNT(*) from #foo

select COUNT(1) from #foo

select COUNT(col1) from #foo

select COUNT(2) from #foo

select COUNT(col2) from #foo

select...

roman.asadovsky (10/15/2013)

MyDoggieJessie (10/15/2013)

There is virtually...

I've been known to use "SELECT COUNT(*) from SomeTable with (INDEX=1)" so that I DO load the entire table.

Generally this would only be in a situation...

Although it's hard to find this information until you've selected which SQL Enterprise 2012 you're downloading from the VLSC, (It doesn't even tell you on MSDN) the "Core" edition is...

While it may be an overly simplistic view of the situation, consider this: Each thread, in isolation, can run on a single core, which is now clocked at 2.1...

The author did a fine job discussing the different approaches. The article shows once again that never and always are both almost always never the correct answer.

@Lamprey13:

The problem existed in SQL 2005 as well. The query plan generator treats the literal 1 as an integer, and implicitly converts the in-row data to integer....

I appreciate the response, but I don't think you understand what I was asking. I don't want to share a machine between two clusters.

I want to make a three...

None of the provided answers are statements, therefore the correct answer should be none of the above.

I would suggest verifying that the recovery model is in line with how the backups are being taken. All too often I have taken over a server that is...

I'm pretty sure that the DBA doesn't need to know the physical architecture behind a SAN. I do, because I'm both the DBA and the storage engineer, but that's...

Have you checked the IO performance of your disks? There's a tool called IOMeter that is very handy for seeing if your drives are slow.

Sometimes a slow drive is...

I believe the errors you are seeing are the "access denied" part of "server does not exist or access denied".

Did you remove the builtin\Administrators group from the SQL server logins...

It is very unlikely that the CPU or RAM have very much to do during a restore. The Network is not suspect in this case, because there is a...