I'd like to understand from a high level what's missing from Standard SQL edition where parallelism is concerned. I thought it was only for special index operations and file partitions that it was choked.
Our new SQL Analyst is trying to help fill the non-existent DBA role, and he's telling me that queries are slow because "Standard edition doesn't have parallelism - it's disabled. We need Enterprise Edition."
I've done a bit of query tuning, and I haven't run into this before, so I'd like a reality check on just what kinds of things are limited by using Standard edition and what to watch for to know when we're up against that limitation.
When I estimate plans for existing operations (example attached), I see lots of elements of parallelism. Are we talking about two different things?