Execute SQL Query On Single Processor

I had to execute a query on my system and wondered how a parallel execution on single processor differs from executing the same in multiple processor,so i have used this small fragent or so colled option to force my query to run on single processor, surprisingly the results where faster when compared to multi processor execution .. Also do rember this does not apply to all queries, will be trying to find the reason for this abnormal but awesome behaviour

So how to Force Execute on Single processor?

At the end of your query just give

OPTION (MAXDOP 1)

 

Example:

Select *

From DB

OPTION (MAXDOP 1)

 

Try it out and see performance difference using the Execution Plan Tab on VS!

Advertisements

[Glitch] One App in IOS Folder

Ok we know that if we drag an icon on top of another we can make them both go into a folder

So how do you put a Single app in a folder?
Here is how it is done:

  1.  Create a folder- Normally how you do that.
  2.  Now remove all the apps from the folder , just leaving one app in the folder
  3.  You are now left with one app in the folder :p

Who and Why should you do this?
–Fun–IOS Glitch–Bug– 😛

Screen:

20110919-015716.jpg