+1,000,000!!!

We were able to get this to work by copying xmlrw.dll from another VM to this VM.    I would prefer to understand why this file wasn't in place, but...

I envy people that can work at that level, as well. 😛  While I still work hard, I no longer want to work THAT hard.  😀

Shifting gears a bit, I got an email at 2:33PM my time about a job posting in linked in... here's the link...

https://www.linkedin.com/jobs/view/3625596996/

I took a look at it at about 3:30PM...

But bottom line, how do you write good, detailed job descriptions of the job you're trying to fill, when you don't know enough of the skill you're interviewing for,...

@steve-2 Jones,

What would be cool is if you posted some of the job descriptions that your friends and clients are posting and well as a bit of candid talk about...

It may help if you posted the actual xp_CmdShell call that you're making to BCP.

It also sounds like the default path (at the DOS level) when you simply make a...

• This reply was modified 2 years, 7 months ago by Jeff Moden.

FLOAT uses 8 bytes (total of 16 bytes and possibly not appearing as you might like).  A DECIMAL (9,1) and DECIMAL(9,2) each use only 5 bytes.  So my first question...

The real problem is that even the "Actual" execution plan is riddled with estimates and the % of Batch junk is the worst.  It's pretty easy to create a couple...

I'll recommend that you can mitigate risk by (as previously stated) first making sure that the index is not a unique index and ,second, just disabling the index and see...

Yes... the QUOTENAME is supposed to be used just to make the sample data and isn't required to be posted.  It...

If you want better help, please post your example data as "Readily Consumable" data instead of a graphic.  See the article at the first link in my signature line below...

All that hype and it still produces incorrect answers to simple SQL questions that won't even execute.  And, it's method of posting (in one case) 30 different links to things...

My Dad told me when I was quite young that "Half of all that is written is wrong and the other half is usually written in such a fashion that...

Lordy... such companies exist but, man, they're very rare.  Most companies are like the one you speak of... they've adopted a horribly misshapen, grossly incorrect, interpretation of what "Agile" is...