@swasheck Working on a method for creating AGs through PoSH. Didn't see much out there on how to do it, wanted to compare notes if you guys had your own method.
In the last sentence of this article (about mapping data from relational databases to a Resource Description Framework graph) some SQL issue is mentioned which is simply referred to as the union bomb. Could anybody please explain this phenomenon?
At seemingly random times, the call to the linked server returns a generic error
Then the problem seems to self-correct
Tonight I noticed that if I ping with large packets out from the SSAS server (which has jumbo frames enabled) to various destinations, the packets get fragmented and delivered successfully
However, if I ping with large packets (> 1500 bytes) from the SSAS server to the Database Engine server that is calling the linked server, the packets just time out
They should get chopped into tiny bits and delivered
The funny part is that the database the stored procedure is in is actually the data source for the cube that it's calling over the linked server
So the MDX query is returning data that came from the relational database in the first place
In the last sentence of this article (about mapping data from relational databases to a Resource Description Framework graph) some SQL issue is mentioned which is simply referred to as the union bomb. Could anybody please explain this phenomenon?
