My first inclination about this job is to abandon it... no, I didn't say rewrite it... I do mean "abandon it". This will change the Fill Factor on all...

Heh... that about does it for me, Adam... I'm going to pivot the PIVOT command right into Unit 0 and use the old school methods I demo'd for this type...

Hard returns are CHAR(13)... Soft returns are actually vertical tabs (CHAR(11))... if that's what you meant...

I don't believe that would work on something that looks like this...

"Some Company with a very long name","somedata","some other data"

"Some Company","someData","some other data"

"Some Company with a very long name","some very...

Heh... you beat me to it, Noel... I'd rather fix the problem than make a patch and I'm thinking that the problem is just bad code to start with. ...

If you setup a BCP format file correctly and use Bulk Insert, that problem will magically disappear... performance problems will probably disappear, as well. I've used Bulk Insert with...

Thanks for the feedback, Jacob...

Yeah, the "same old trick" you're be speaking about is the aggragates themselves.

Always a pleasure, MrPoleCat... and thanks for the feedback.

Something had to have changed in the environment... for example, the login that SQL Server uses to start services... it may have been changed permission wise on the Windows Server...

You haven't mentioned whether or not you're using an explicit transaction around all of those inserts and selects... that would be a real big cause of the deadlocks.

You might want to take smaller bites when inserting, as well. Insert a couple of hundred thousand using a control (ugh!) loop.

If the data is being inserted from, say,...

Until they fix it, there's a work around...

1. Put your cursor one line above the code box.

2. Click and drag to one line below the code box.

3. ...

Heh... understood... I still kick myself for some of the things I've done to a database in past lives 😀

Wouldn't really be an extra column and no tradeoff that I...

I'd still be tempted to make the formatting in a calculated column for the app so I could easily create reports like "How many emails did we send today?". ...

My problem with a mega-watt satilite would be that some idiot would figure out a way to turn it into a beam weapon. ION drive? Way cool application...