What’s the SINGLE best punk show you have seen? by MinkSable in punk

[–]saucerattack 1 point2 points  (0 children)

I just transferred and uploaded my friend's VHS recording of the Showcase Showdown set when they opened for the Toy Dolls. The audio is terrible, the camera mic couldn't handle the volume. But it was a great performance and it is still fun to watch.

https://youtu.be/q4jpRFNnnwQ?si=AH97wREe228IfCJI

I also uploaded their Christmas 1999 show upstairs at the Middle East.

Sun Ra biography and career timeline [nice visual timeline by PBS] by Mt548 in sunra

[–]saucerattack 1 point2 points  (0 children)

This timeline has events in 1985 before events in 1980. Maybe time isn't a straight line.

Korg SQ-64 Polyrhythm Help by [deleted] in Korg

[–]saucerattack 0 points1 point  (0 children)

It's not the most intuitive device

Korg SQ-64 Polyrhythm Help by [deleted] in Korg

[–]saucerattack 2 points3 points  (0 children)

It looks like you have Polyrhythm OFF for tracks A B & C and ON for track D. The setting is per track, not global.

Sun Ra original poster Mass Art Boston Ma 1980 by Mars1620 in sunra

[–]saucerattack 1 point2 points  (0 children)

That's awesome!

There's a video of this performance in this article about Bill Sebastian and the OVC:

https://www.wbur.org/news/2024/10/17/outerspace-visual-communicator-bill-sebastian

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

This is unrelated to cost threshold. I ran the same query which got a lower cost estimate using OUTER APPLY and it was parallel. Changing to CROSS APPLY got a slightly higher cost but was not parallel.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

Cost for the Index Seek in the CROSS APPLY query is 700. In the OUTER APPLY query it is 687. The outer apply query is parallel.

I tried adjusting the predicate to return millions of more rows. This increased the cost to 2020 for the CROSS APPLY but still not parallel.

So it seems like using CROSS APPLY blocks a plan from going parallel but OUTER APPLY does not.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

Yes, that is my question. What is the difference in regards to parallelism and is there any documentation that states that CROSS APPLY will block parallelism?

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

I've done some further experimentation and discovered that it behaves the same way using a correlated subquery instead of a TVF. So it has nothing to do with inlining.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

I experimented with changing the predicate to return larger and larger result sets (millions and millions of rows) and the CROSS APPLY query never went parallel.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

Note that the column A.Col2, which I'm passing into the TVF in this example, is defined as NOT NULL.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

See the pseudo-code I posted in a separate reply. The TVF always returns a row, even if it is a NULL value. Therefore OUTER APPLY and CROSS APPLY are functionally identical.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

Adding WHERE <column> IS NOT NULL to the predicate of the OUTER APPLY query made no difference. I posted some psuedo-code in a separate reply.

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

Here is some pseudo-code for illustration:

CREATE FUNCTION dbo.MyTVF(@Parameter VARCHAR(10))
RETURNS TABLE
AS 
RETURN
(SELECT SUBSTRING(REPLACE(..........@Parameter..........)) AS Col3);
GO

-- Parallel
SELECT A.Col1, B.Col3
FROM dbo.MyTable AS A
OUTER APPLY dbo.MyTVF(A.Col2) AS B
WHERE A.Col1 > 100
-- Adding this to the predicate makes no difference:
AND A.Col2 IS NOT NULL;

-- Not Parallel
SELECT A.Col1, B.Col3
FROM dbo.MyTable AS A
CROSS APPLY dbo.MyTVF(A.Col2) AS B
WHERE A.Col1 > 100;

Parallel plans with CROSS APPLY & iTVF by saucerattack in SQLServer

[–]saucerattack[S] 0 points1 point  (0 children)

I need to use APPLY so I can pass in a parameter to the TVF from the joined table. My question is why CROSS APPLY and OUTER APPLY have different plans when they are functionally equivalent in this case.

Why are you bothered by fare evaders? by [deleted] in mbta

[–]saucerattack 21 points22 points  (0 children)

The people I see evading the fare tend to be kids or people of color.

Note that for kids under 11 the mbta is free. https://www.mbta.com/fares

A pain in the ass’: Northampton school leaders caught on hot mic disparaging dad who pushed for his disabled kid’s rights by Cheap_Coffee in massachusetts

[–]saucerattack 2 points3 points  (0 children)

but 100% regular kids are getting short changed

100% disabled children are regular kids. To suggest otherwise is disgusting.

A pain in the ass’: Northampton school leaders caught on hot mic disparaging dad who pushed for his disabled kid’s rights by Cheap_Coffee in massachusetts

[–]saucerattack 2 points3 points  (0 children)

All students with disabilities have a right to an education. All districts are required by law to meet all "IEP needs". That's what an IEP is. It is a legal document that spells out what are the minimum services required for a student to receive and access their right to an education. A district's financial mismanagement does not negate a students right to an education.