Actually to correct my original post, the Min/Max settings are 60/4.

Thanks for your suggestions and it is a physical server. I continued to research and I seem to keep going back to the physical hardware itself, but it will be...

I appreciate all the comments and realize some heavy hitters responded and I appreciate it!!

I am testing on my DEV box as time persists as it is month end and...

Okay, so I cannot post the code due to the issues / privacy regarding what we do. I will clarify though as much as possible.

We run analysis for casinos based...

I appreciate the answers and to clarify there is definitely filtering involved in the procedures so I will do some tests with a few different heaps and document the difference....

Her reason why she didn't want it was it wouldn't make enough difference because of the size of the heaps and calculations they do, but I don't think that is...

Just to clarify I will check the frag on all databases that I have this issue with. Each database has heaps without any indexes or primary key. It is data...

Thank you both for your responses! I do realize that shrink is not popular and haven't nor do I want to do it. I was looking for responses about it...

I have a question though. SSIS was installed after SQL Server was and wasn't touched for a couple of months.

When SSIS was installed if Database engine wasn't selected could...

I wondered that, but I have given her almost everything other than sysadmin rights.

I'm still looking and will eventually figure out the issue.

Thanks

Currently she can't even see it from her client and it is on the same domain.

Although if she remotes into the server she can right click as Administrator and log...

I am. Thank you for your responding!

It is just us two as this is a very new project and no one else here has a clue about Database. The people here think Excel is a database....

The...

She is currently developing stored procedures to automate several reports. Not sure what they have planned for her down the road.

She has asked for sys admin rights because we are...

Yes, I did try that to weed out and it did work.

After looking up threads, I realized it was an extra permissions issue I was not aware for SSIS. Once...