News: Why You Don’t Get Parallelism When You Ask for The Whole Table

New from Brent Ozar on Get Parallelism.

Let’s say you’re working with a big copy of the Stack Overflow database, and you wanna get all the users, like for a data export. SQL Server doesn’t parallelize this query, not even if you use the query hint that…

Read the full article at Brent Ozar