Thanks, Scott and Jeff, I like your ideas.

Thank you for replies.

The first thing we did was upgrading from RTM GDR 13.0.1742.0 to the latest build SP1 CU7 13.0.4466.4. It improved things, we are watching if...

Thanks for the replies.
In the past, I tried both things you suggested and they didn't work for me.
Moving the file didn't work. The SQL Server didn't recognize the...

Thanks for the answers.

I have only C, D and E. C is system, D and E are for data. From a separate research, I concluded that logical drives...

Thanks.

The mechanism is still not clear to me. I add index with an CREATE INDEX TSQL, not using any design tools. Is SSMS that smart to add an...

Thanks, maybe it indeed didn't fail.
Can you please elaborate in short what could have happened? There was indeed a CREATE INDEX statement for the table but how could it...

Yes, I confirmed that this was the case, thank you!

I killed that session as soon as I realized it was the culprit in holding other sessions up, so I can't tell now if there was a transaction open. But...

I don't think so. He ran it in SSMS.

Thanks, Craig, the sub group is exactly what I need.

The question is about the Return-path which is a different header. After more researching I tend to think it is omitted intentionally since it is supposed to get set dynamically...

Thanks, Craig, this definitely helps.

Customers systems actually send export files, then, already on our end, we have a process that parses the files and write messages to queues. On...

Thanks.

We don't use SSIS, everything is done by a Windows service with regular INSERTs. The Windows service gets records to insert from MS queues, one queue per table that's why...