Yes. I believe you can use copy only, which avoids this, but why not just use the LS backups.

Grant Fritchey (7/16/2014)

---

That's a giant topic and it's kind of hard to give you too much guidance in a forum post. Yes, most tables should have at least a clustered...

GilaMonster (7/16/2014)

---

I would be, if he were worrying in the right...

I agree

The easiest way is to use a trigger and the updated() function on this field to catch changes. I'd build an audit table and record the changes there, adding a...

Moved to. MySQL forums

Checkpoints are issued regularly by SQL Server to flush dirty pages to disk. You can manually issue them as we'll.

In terms of IO, it depends on the rate of...

This shows some of the calculations used in the new and old estimators. The 2012 version is the old one:

http://blogs.technet.com/b/dataplatforminsider/archive/2014/03/17/the-new-and-improved-cardinality-estimator-in-sql-server-2014.aspx

It's not a complex calculation, but it requires a bit of...

There isn't a way to restore data without a user being locked out of the table it is stored in. The Online Restore allows you to partially restore a filegroup,...

'

Thanks.

Back now, a good suggestion.

I'll send it along.

Is this still occurring?

Checking on this now. Apologies for the delay.

That shouldn't be the case. Were there multiple answers? If so, you need to include them all.

We haven't changed the QOD engine, so I doubt it's a bug. Potentially someone...

Likely it was a transient thing, or perhaps we broke something with an update.

Please report it again if it happens.