My question would be... why do you use a resource intensive, slow as a While loop recursive CTE as your sequence generator?  There are many better methods.  See the following...

We copied xmlrw.dll from a working machine to the /system32/   and /SysWOW64/ directories on our Azure SQL VM in order to get this working.  I think system32 was...

Thank you, Jonathan. Almost every step in the execution plan now marked as "No Join Predicate" and the whole function now costs 100% with my original tally one costing...

THAT, my friend, is the very problem with 99.9% of the world. 🙂

As Michael...

Hi

To stop transaction log growth, our index rebuild process changes databases to Bulk Logged from full recovery and then back again at the end of the process.

What we've noticed,...

+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, 9 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...