It is like almost "share nothing" as each thread/connection is separate with an exception for a shared data page cache. Sometimes queries can be parallelized but that is an "advanced" feature.