I haven't used it for SQL Server 2012 in particular, but this should work fine as a test environment (although technically, probably not a MS supported configuration).

Not sure mapped...

There's no performance or data size difference as they're variable length data types, so they'll only use the space they need.

Think of the size parameter as more of a useful...

The Dixie Flatline (8/19/2013)

---

Just looking in a minute, while stopping to grab a donut. I feel compelled to ask this water-cooler question. Have...

Steve Jones - SSC Editor (8/19/2013)

---

Ed Wagner (8/19/2013)

---

Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to...

Personally, I'd label this as a bug and it's quite annoying, but I believe this happens because of the large data types in row optimisation.

If the original data was small...

SOS_SCHEDULER_YIELD are generally a sign of CPU pressure, although in this case, it could be overallocation on the host.

VMware is meant to be very clever in the way it...

Can't think of any logical reason if...

I can't see how snapshot backups could cause the error message reported by the OP. I can see how you can break the expected differential chain by doing a snapshot...

I'd avoid delete and rollback, it's needlessly expensive. If you don't need the delete, just put the equivalent logic in a SELECT statement to capture the count.

This usually happens when you're not using a Windows login with permissions to start/stop/restart the services. Note that these aren't SQL Server permissions, they're permissions on the Windows server.

I've had this before when I've had an authenticated proxy server that doesn't allow other applications out over the internet. I think the reason is that SSMS 2008 (not sure...

I'm not sure that's going to be a representative benchmark for columnstore indexes.

The point of them is to support many thousands of variations of different combinations of predicates, group...

Could you share the DDL and queries you used for the benchmarks?

Stefan Krzywicki (8/13/2013)

---

L' Eomot Inversé (8/13/2013)

---

The things you're not doing...

SQL Trace and Perfmon on the guest are only showing you part of the picture.

Even if you've gone for a 1 to 1 mapping of host/guest, these are the things...