Hi

I have been working remotely now for the last 3 weeks and so far it has all been good. Though today I need a short "mental health break", which is...

Excellent stuff. I have managed to get it working on a new SQL Express 2016 server.

Thanks GilaMonster, thats exactly what I needed. I knew there was the ability to do something like that but could not remember exactly what.

Again thanks

No worries, I suspected that would be the answer.:-)

Looks like I can answer my own question. After a bit more searching I see that if multiple users run the procedure that creates temp tables they all have there...

Thanks 🙂

will do 🙂

Thanks

Brad

Overall things seem to be running OK, but it has been on the smaller of the 2 database's that performance has been poor.

Installed a copy of RedGates SQL Index Manager...

Its a 3rd party application, so we have no access to the queries, etc that are being generated...

Thanks anyway.......

Have loaded a Trial Version of SQL Index Manager and found a...

Damn....My problem is that we have a 3rd party application that access 2 databases. Structurally they are identical, but access to one is fine where access to the other is...

So far, by disabling the TCP Chimney Offload feature our issue seems to have been resolved.

Brad

We are about to disable the TCP Chimney Offload feature. After about 8 months of the occasional failure we have been able to isolate it to this feature (see MS...