Sliding Scale Parallelism: Why Stop At DOP?
Erik Darling wonders why SQL Server doesn't have more granular parallelism options.
2017-08-09
3,671 reads
Erik Darling wonders why SQL Server doesn't have more granular parallelism options.
2017-08-09
3,671 reads
Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.
2016-05-26
2,732 reads
2011-10-19
1,800 reads
SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.
2011-03-08
4,900 reads
How to configure settings to limit the number of processors used in parallel query execution
2009-04-20
3,121 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers