Sliding Scale Parallelism: Why Stop At DOP?

Erik Darling wonders why SQL Server doesn't have more granular parallelism options.

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.

Nested Loops, Parallelism and Confusion

I’m 30 today.
In addition, it’s been 10 years since I started working with SQL Server.
In my twenties, I fell in...

Maximum degree of Parallelism

Understanding and Using Parallelism in SQL Server

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.

Is hyper-threading still relevant for SQL Server?

There still seems to be a lot of fear, uncertainty and doubt, in the community, with regard to use of Hyper-threading (HT) with SQL Server workloads. So, how and when should it be used?

Configuring the Maximum Degree of Parallelism

How to configure settings to limit the number of processors used in parallel query execution

RE: VBScript Error Object Required

Can you check your gvEmailList and see if this is being populated?  IF this is NULL or NOTHING THEN the RS would be NOTHING as well...

RE: Error importing from EXCEL

hello people,Sorted this one myself... managed to find thishttp://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ281517cheers anyway Tim

XML Bulk Load & Truncating Data

I have a table with a number of columns type varchar(70), and a few others of specific sizes taking it up to the maximum row size.The data for the varchar(70) columns occasionally exceeds 70 characters, and I want this simply truncated, however I cannot do this in the application that creates the XML Files because this […]