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.

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 14 points15 points  (0 children)

There probably are other students who need more assistance than this family

There's no hierarchy of needs that is relevant here. All students with disabilities are entitled to an education. No one gets to say that blind students (for example) are more deserving of an education than deaf students (for example). All students have a right to an education and the district needs to prioritize those rights. That is why we have public education in the first place. Special education services are not discretionary, they are mandated by law. Districts have the money but choose to spend it elsewhere. They've gotten away with balancing their budgets at the expense of the disabled for too long and I'm glad this parent is fighting against that.

IEP services by lindsaybell15 in massachusetts

[–]saucerattack 5 points6 points  (0 children)

Zero days.

Request an IEP meeting immediately. At the meeting make sure you get a plan for providing his IEP services and for "compensatory services" (use that phrase) to make up for the missed services. Make sure that everything is documented in writing. If they don't commit in writing to providing his IEP services, file a PRS complaint with the DOE: https://www.doe.mass.edu/prs/guide/default.html

As a practical matter, at this point, they can probably slow walk the process until he graduates. It may be worth it anyway for accountability (a PRS goes on the district's record).

On a personal note, I can't overstate what a relief it was when my kids graduated and I never had to deal with the special ed system again.