Viewing 15 posts - 286 through 300 (of 1,988 total)
Hmm... what happens if you use the -n flag instead of -c?
January 7, 2021 at 4:45 pm
All of my output files are less than 20,000 lines. If your output file is greater you may need to look at a batch size to save on memory.
There's also...
January 5, 2021 at 3:34 pm
carlton 84646 wrote:Can I also point out, that I'm trying to achieve the result without using LEFT JOIN
Curious, what issues will a LEFT JOIN cause?
Duplicates - requiring DISTINCT or...
January 4, 2021 at 9:10 pm
We started 4 days in office 1 day WFH several weeks before going permanent WFH for covid. We've been back on 4 days in office for the most part for...
January 4, 2021 at 3:34 pm
First thing that comes to mind is simple INSERT triggers. However, generally, I don't like triggering behaviors. Instead, querying usually works better and isn't masked.
This seems like one...
December 1, 2020 at 4:32 pm
Hmm... okay I see what you're saying. It seems to be something to do with extremely small tables. And both truncating the table or simply inserting a chunk of data...
November 6, 2020 at 2:40 pm
Right but the transaction doesn't know the record doesn't exist until it tries to find it, which requires locking it.
November 5, 2020 at 8:30 pm
The first part of ACID is atomic, transactions either commit or rollback as one unit, they don't do partial units of work.
I don't see this as any different than if...
November 5, 2020 at 7:35 pm
I would see that more as an object lesson in not doing long running transactions on tables that might be highly active.
November 5, 2020 at 7:15 pm
You don't have a commit or rollback on the transaction.
November 5, 2020 at 6:59 pm
I don't particularly care if they're bundled as long as I can still install SSMS easily and SSMS is kept up to date.
As for functionality? If I was purely doing...
November 2, 2020 at 4:24 pm
If I understand SO correctly, all they want is an answer, not necessarily the best answer. Also, don't try and have a discussion as they will shut you down.
Most...
October 30, 2020 at 4:15 pm
The biggest push back I see where I work is that there's not really a notion of admitting maybe your part of the puzzle could be the problem. The initially...
October 26, 2020 at 4:21 pm
Viewing 15 posts - 286 through 300 (of 1,988 total)