May not be the best idea, but you could also figure out the number of records that are about 5 GB, insert them into a WorkTable, and then delete those...

Rudy,

Thank you for the reply.

Andy

Rudy,

Do you ever have problems with vCPU wait times(I hope that is the correct term) since you're allocating so many CPUs to your SQL Server? Our VM guys suggest...

TheGreenShepherd,

Ok, I promised an update on testing once I had one. Well, this one is not great, but here it is. This is an existing process so the...

opc.three,

That is exactly what I'm looking for. Thank you so much. Almost forgot to answer your question, unfortunately upgrading is not an option right now.

TheGreenShepherd,

The main developer is...

I'm not super familiar with the performance impact of WCF in this sort of a setup, but I can tell you this - SQL Server, at a basic level, requires...

I truly like where I work. I have a great team, manager and director. Heck, even the CIO is a great guy. The only thing I would...

Thank you for all your help!

Both users were originally in IT GLOBAL which has Browser and My reports access to the specific report. However, only the user that had access was originally in...

The non-access user that was added to NW_Reports now has access to the specific report. Could this be an issue in AD?

We checked AD. One of the users who had access to the specific report was in an additional group, NW_Reports. The user who did not have access to...

No. But, they had problems with this access originally when this SSRS install was on a physical SSRS server. This SSRS server was just moved to a virtual machine....

Thank you so much.

That's great to hear! Can I ask what the applications transaction volume is daily?

Thank you. I was just wondering because the research I have done so far seems to indicate that the queries can be pretty bad from LINQ/EF. You can't...