Geek City: A Hint of Degrees

Posted by Kalen Delaney on SQL Blog See other posts from SQL Blog or by Kalen Delaney
Published on Tue, 03 Jun 2014 19:30:00 GMT Indexed on 2014/06/03 21:34 UTC
Read the original article Hit count: 233

Filed under:

hints

|

Parallelism

This is just a quick post to describe a test I just ran to satisfy my own curiosity. I remember when Microsoft first introduced the query hint OPTION (MAXDOP N). We already had the configuration option ‘max degree of parallelism’, so there were lots of questions about how the hint interacted with the configuration option. Some people thought the configuration option set an absolute maximum, and the hint could only specify something less than that value to be meaningful. Other people thought differently,...(read more)

© SQL Blog or respective owner

Related posts about hints

Text Hints with JQuery and JavaScript for loop

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys! I'm developing a small app where i ask users to put some info. I want to show text hints in the input fields. I do this in a for loop... When the page is loaded, the hints are displayed correctly but nothing happens on 'focus' and 'blur' events... I'm wondering why since when I don't use… >>> More
Netbeans 7.2 Missing Modules Warning

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Everytime I start Netbeans and the splash screen shows up when it gets to the part to load the modules I receive the following error message : Warning - could not install some modules: Editor Library 2 - None of the modules providing the capability org.netbeans.modules.editor.actions could be… >>> More
Geek City: A Hint of Degrees

as seen on SQL Blog - Search for 'SQL Blog'
This is just a quick post to describe a test I just ran to satisfy my own curiosity. I remember when Microsoft first introduced the query hint OPTION (MAXDOP N). We already had the configuration option ‘max degree of parallelism’, so there were lots of questions about how the hint interacted with… >>> More
SQL SERVER 2008 JOIN hints

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, Recently, I was trying to optimise this query UPDATE Analytics SET UserID = x.UserID FROM Analytics z INNER JOIN UserDetail x ON x.UserGUID = z.UserGUID Estimated execution plan show 57% on the Table Update and 40% on a Hash Match (Aggregate). I did some snooping around and came across… >>> More
PHP: Type hints for fields with Eclipse PDT

as seen on Stack Overflow - Search for 'Stack Overflow'
Using Eclipse + PDT, I know that you can specify the return type of a method or the type of a variable within a method via type hints. How about class fields? Can I declare the type of a field in order to enable autocompletion for that variable? I tried something on the lines of: class MyClass… >>> More

Related posts about Parallelism

Parallelism in .NET – Part 3, Imperative Data Parallelism: Early Termination

as seen on Reed Copsey - Search for 'Reed Copsey'
Although simple data parallelism allows us to easily parallelize many of our iteration statements, there are cases that it does not handle well. In my previous discussion, I focused on data parallelism with no shared state, and where every element is being processed exactly the same. Unfortunately… >>> More
Parallelism in .NET – Part 2, Simple Imperative Data Parallelism

as seen on Reed Copsey - Search for 'Reed Copsey'
In my discussion of Decomposition of the problem space, I mentioned that Data Decomposition is often the simplest abstraction to use when trying to parallelize a routine. If a problem can be decomposed based off the data, we will often want to use what MSDN refers to as Data Parallelism as our… >>> More
Parallelism in .NET – Part 4, Imperative Data Parallelism: Aggregation

as seen on Reed Copsey - Search for 'Reed Copsey'
In the article on simple data parallelism, I described how to perform an operation on an entire collection of elements in parallel. Often, this is not adequate, as the parallel operation is going to be performing some form of aggregation. Simple examples of this might include taking the sum… >>> More
Parallelism in .NET – Part 6, Declarative Data Parallelism

as seen on Reed Copsey - Search for 'Reed Copsey'
When working with a problem that can be decomposed by data, we have a collection, and some operation being performed upon the collection. I’ve demonstrated how this can be parallelized using the Task Parallel Library and imperative programming using imperative data parallelism via the Parallel… >>> More
Code for Parallelism Features Tour

as seen on Daniel Moth - Search for 'Daniel Moth'
Last year I linked to a screencast that shows off many VS2010 features delivered by the Parallel Computing team.There have been requests for the code used to demonstrate the features. Like with all my screencasts, you can see all the code in action, so you could simply type it in. To save you doing… >>> More