Viewing 15 posts - 106 through 120 (of 604 total)
fixed issue - developer was using dbmail
September 21, 2015 at 9:26 am
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...
September 14, 2015 at 10:43 am
auto shrink if OFF
I do manually shrink the t-logs once a week due to space issues.
September 14, 2015 at 10:20 am
Okay thanks guys. I'll leave it be.
Thanks again for all the info
September 11, 2015 at 2:18 pm
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...
September 11, 2015 at 1:53 pm
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...
August 27, 2015 at 10:57 am
Concurrency Violation:
The update command effected 0 of the expected 1 records
August 27, 2015 at 10:43 am
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...
August 27, 2015 at 8:38 am
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
August 18, 2015 at 6:21 am
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,...
August 10, 2015 at 9:32 am
Jeff Moden (8/8/2015)
My first question would be, did you rebuild the indexes and the statistics? Also, have you installed the good version of service pack 1?
Jeff - u may...
August 8, 2015 at 11:35 pm
You were correct Jason. Good call. Thanks.
August 8, 2015 at 11:26 pm
Thanks Jeff forgot about SP1
August 8, 2015 at 11:25 pm
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...
July 29, 2015 at 10:28 am
Viewing 15 posts - 106 through 120 (of 604 total)