fixed issue - developer was using dbmail

I just noticed that allot of the fragmentation seems to be on HEAP tables.

So if I exclude the HEAP tables I still have 100 tables that have fragmentation over 20...

auto shrink if OFF

I do manually shrink the t-logs once a week due to space issues.

Okay thanks guys. I'll leave it be.

Thanks again for all the info

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...