when I executed a join query, I got an error:
emporary file size exceeds temp_file_limit (65536kB)
but I got results finally selecting from a view instead which is exactly the same as join query. it's weird.
There should be no difference between view and the query under it, right?
The fol...
I'm still new to Postgres so my question. However if you feel it is not the correct place, I'll ask it somewhere else.
I'm trying to create a trigger inside of a postgres rds db hosted in Frankfurt that we will call Frankfurt. That trigger will poll tables in a distant postgres rds db hosted in ...
Grammar was probably improved (slightly). I also agree with his resetting the formatting, seems more readable this way. I don't know why he removed "Basically", but that's not a big issue. What's more serious is that he introduced two spelling errors. My biggest issue is his changing a "?" to a "???". Why???????
@sp_BlitzErik This is a great line: "If you stick a goofy subquery in, the optimizer will regard it with contempt and suspicion, and give it a full pat down."
@TomV This is certainly not the first time that I have been considered "unreasonable" ;-) (yes, I know that's not what you were saying). Still, it is an interesting and elusive problem and I enjoy figuring these things out :-).
@sp_BlitzErik Dog gone it, now I need to thank you again for those kind words (wasn't kidding when I said I don't know how to take a compliment). But seriously, thank you very much. And yes, I do need to thank you (and the others) as nothing needed to be said, but yet you took the time (even if just 1 second) to compliment and that act should be acknowledged.
@AndriyM I agree, I don't see any spam, just an unclear question
I'm unsure about that edit by John though
Hi there, welcome to the site. It's a bit hard to tell what's actually happening without more information. Could you share the input, the actual powershell script and the truncated output? — Tom V9 secs ago
My friend is struggling on finding an answer to his issue. He's trying to create a cross reference in the db via C#. Should I post the question here and see if you could help out? Or should I bring him here?
The short summary from his question is he is trying to display a reference from Case A to Case B and he wants Case B to be able to recognize there is a reference from Case A.
TLDR: I am trying to display a reference from Case A to Case B and I want Case B to be able to recognize there is a reference from Case A.
In my application, I have a section where I connect Cases to each other in order to see their relationships (ex. Brother, Sister and etc.) This section is ca...
"This issue" is probably a known problem type, but Case A, Case B, PS-100000, and PS-100002 have no intuitive value to me, so understanding the problem would take a lot of effort.
The general room is usually for casual conversation. Questions can be discussed of course but if they get lengthy, it's better to have a separate room.
A benefit is that - even if you can't find the solution now - you can add a link to the room under your posted q at SO, and future readers can see the the discussion, which may help them answer
@JoeObbish Well, with that definition, I can say that I have been able to create a 4-byte "character" in VARCHAR. NVARCHAR is harder to determine given that combining characters just pile on and I am not sure if there is a specific limit. For example, I just created a 606 byte single "character" that includes 300 diacritics ;-)
A small version of it is (though not sure if it will show up correctly here): u̐̐̐̐ͨ Well, it does look like it works, so let me try something really odd:
Here is the 606 byte "character": u̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐̐ͨ
We at Stack Overflow are interested in setting up a security bug bounty program to begin rewarding users monetarily who report serious security vulnerabilities to us, and we want to know what the community thinks. This program will be run through HackerOne where we are currently testing features ...
@TomV and @sp_BlitzErik and @JoeObbish and @Forrest : try the following on dbfiddle (and you can try for yourself to copy and paste that single "character" and paste it into SSMS: dbfiddle.uk/…
@Forrest There are a few ways, but I did this one using the following: SELECT N'u' + NCHAR(0x0310) + REPLICATE(NCHAR(0x0310), 300) + NCHAR(0x0368); Also note that I just picked 300 as a random amount, but it could be 3000. Although I just changed it to 3000, reran, copied it, and pasted, at which point SSMS crashed ;-)
Yup, the 3000 diacritic "character" can be copied, but not pasted, at least not into SSMS ;-) Though I can paste it into Notepad++ (yet another reason that is the best editor)
I was about to ask about AWS migration, but found it addressed on SO. That question is more than 60 days old, and therefore it can't be migrated (I believe). Still, it's a DBA-related question, and the answer may change as Amazon adds capabilities. It would be valuable to have it - or a copy o...
Trying to figure out how. I don't see it in practice very often
you might need a partition by column
SELECT SUM(a) OVER (PARTITION BY a) FROM dbo.eric_t OPTION(USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'));
that goes parallel, though obviously results change
this goes parallel, but with an additional sort: SELECT SUM(a) OVER (PARTITION BY a % 1) FROM dbo.eric_t OPTION(USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'));
Serious question: if I use a VARCHAR(64) as a PK, on a table with ~1000 rows or so, and there are NO FK's to this PK, will the performance of it become a concern? Frequent reads, rare writes.
Scratch that, it's NVARCHAR(64) but the same question applies.
I know I'm looking at an excess of 24.8kB of overhead in the PK index (compared to using an INT, for example), but I'm concerned if that will affect SELECT performance a lot / noticeably (when it's always a SELECT *).