We had a one time run that filled a huge 45Mil table.

This caused the buffer usage to fill over 32GIG. Now several large queries are running slower.

We would like a...

Sorry Gail I don't think you'd be able to help us further.

The offending program is a third party application that we cannot control.

We were hoping we could fix the error...

Concurrency Violation:

The update command effected 0 of the expected 1 records

We do exactly what you are saying here.

We have a NODEA and a NODEB and we report only from NODEB using application intent= readonly.

Works fine, but there are the...

Thanks Grant

Thanks for the cheat sheet.

Does creating the snap create a full bak or full mdf and ldf files? Im concerned with space - it's a large DB

I added it to the end and I get

Incorrect syntax near the keyword 'OPTION'.

WHERE (dbo.provider_specialty.primary_specialty = 1)

GROUP BY cp.claim_procedure_id, cp.procedurecode_ud, v.vendor_ud, elig.eligibility_ud,...

Jeff - u may...

You were correct Jason. Good call. Thanks.

Thanks Jeff forgot about SP1

I have had a similar issue with logs in AG.

Believe it or not, I found that backing up the log three times in a row and then issuing a shrink...

Yes and yes

I am looking for a way to backup the secondary log...

got it thanks guys

Jacob Wilkins (7/9/2015)

---

There are a couple things I'd check.

First, is the DB using the Full recovery model in the test environment? If it's using Simple in the test environment, that...

Lynn Pettis (7/9/2015)

---

First, your test environment should mirror your production environment to give you a better sense of what will happen in production.

Second, you say in production it uses 600G...