Viewing 15 posts - 1,366 through 1,380 (of 59,066 total)
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...
June 14, 2023 at 2:28 am
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...
June 14, 2023 at 2:01 am
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...
June 13, 2023 at 6:02 pm
Outside of these two things I can't think how doing a defrag would cause performance issues.
THAT, my friend, is the very problem with 99.9% of the world. 🙂
As Michael...
June 13, 2023 at 4:16 pm
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,...
June 12, 2023 at 7:26 pm
June 12, 2023 at 7:05 pm
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...
June 12, 2023 at 7:01 pm
I envy people that can work at that level, as well. 😛 While I still work hard, I no longer want to work THAT hard. 😀
June 11, 2023 at 9:17 pm
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...
June 9, 2023 at 10:18 pm
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,...
June 9, 2023 at 7:10 pm
@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...
June 9, 2023 at 5:20 pm
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...
June 9, 2023 at 5:11 pm
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...
June 9, 2023 at 2:16 am
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...
June 8, 2023 at 6:03 pm
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...
June 7, 2023 at 2:30 am
Viewing 15 posts - 1,366 through 1,380 (of 59,066 total)