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

[Discovered]Galaxy note easter egg

Just found an easter egg on the Samsung Galaxy note n7000
My note is running the stock android Gingerbread

Go to Settings> About Phone > Android Version

Quickly (very very Quick) Tap the Android Version and You Will get the Gingerbread Zombie Image

Here is the Video

 

[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