If you're looking at disk problems, for once, you can leave the VM guy alone and concentrate on the physical box. You may need to wake up the SAN guy...

Millions of rows are not necessarily a problem. It really depends on your indexes and statistics. If you have something like an identity column as the primary key, then you...

When you add something like GROUP BY, the plan is not the same because the processing is not the same. You can't apply a simple SELECT (or even a very...

Nope. Those are different pieces of functionality inherent to the different versions of SQL Server. If there's 2008 functionality needed, it's also going to need the underlying 2008 engines.

There is not a single spot that says "SHOWPLAN Enhancement for 2012". All through the book there are additional pieces of knowledge as they are applicable.

There are few changes in...

There is no way. Sorry.

If it's a dev environment, you may not want to set up extensive backup routines (for many obvious reasons) which is yet another reason to have...

SQLSACT (11/28/2012)

---

Grant Fritchey (11/28/2012)

---

Just remember that the number is an estimate. This means it can be wildly inaccurate. But, it's the only number you get, so you're going to use...

No way I know of to do this.

There is a third party tool, Plan Explorer from SQL Sentry, that will let you open execution plans. But I'm pretty sure you...

You need to look at the execution plan of the query to understand which indexes it accessed. If query time increased, then adding that index did not help.

Just remember that the number is an estimate. This means it can be wildly inaccurate. But, it's the only number you get, so you're going to use it, just don't...

There must be another process blocking your query. That's the only thing that makes sense.

The real question is not what can be backed up. The real question is, what can be recovered. If you take a system backup once a day, then you can...

You can't directly control what gets created in statistics, but you can create specific types of statistics. Try creating a filtered statistic. I'm not sure what you'd filter by in...

No, no, no. I am the pretty guy...

All my experience with replication was transaction replication. In that, if we modified the publisher outside of normal data access, we had to completely rebuild the publication. It was a...