You can invalidate...

That's just normal transactional replication. Providing the person working on the subscriber doesn't delete, insert or change the key values, updates won't break replication. Be aware that his changes will...

Firstly, don 't change minimum memory per query unless you know what you're doing and why you're changing it and the impact thereof.

Do you mean the server's memory usage is...

Lempster (9/15/2014)

---

GilaMonster (9/11/2014)

---

cafescott (9/11/2014)

---

Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a...

Run it again if you didn't save the output. I need to see everything that CheckDB returned.

New as in 'in development' or new as in 'here's an existing system you've never seen before'?

There's nothing wrong with your procedure, you just have to put the...

Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

Consider using a RAMDisk for Index filegroups.

Putting non-clustered indexes on a RAMDisk will...

Please post the full output of that CheckDB statement, the entire thing, no edits, no omissions.

Not really.

they compress the columns into segments and store them on disk as BLOB's, the columnstore...

That's what you get when marketing gets to name features.

The graphical execution plan which management studio can show you, the 'recipe' if you will of how the query is executed.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

defyant_2004 (9/12/2014)

---

I appreciate the reply. Our server administrator is demanding that this be corrected. He believes everything SCOM tells him. I am not sure where start, do...

I suspect the former, though don't know enough about Access.

Same with the SQL corruption...

They're not in the log file. They're perfmon counters.

Don't believe everything SCOM tells you. Buffer cache hit ratio is a fairly useless counter.