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

Hp Slate-Pc That Looks Like A Tablet

Searching for a Pc Having some looks like the tablets that have been sprouting up these days? then you should check out hp slate..Have a look at the features below..may be you get convinced! or just wait for some dual core Tablets to come up? …Take you’r decision…

Name: HP SLATE.

Model: 500.

Type : Pc That Looks Like A Tablet.

Continue reading

Android 3.0 Preview

Google unveiled most awaited Android 3.0 Honeycomb

First thing first ! They say its Completely build for Tablets! look below:

  • Looks like it has really really fast UI..Thanks to Dual Core Processor,that it requires.
  • The browser looks really great and fast movements.
  • Nice interface for Google books,they provided a panoramic view for it.
  • Tablet optimized YouTube and gmail.
  • The best being a 3D View In maps.

8086 Microprocessor Emulator-Windows

An Emulator For Intel 8086 Micro Processor

Godhc: Are You a Programmer at hardware level?

Buddy: Yes,i am and i am using famous Intel 8086 Micro Processor in my institute!

Godhc: So Whats the problem?

Buddy: In my institute,they have the hardware and software to program,but i want to try in my home,how can i 😦

Godhc: Thats simple buddy Download an Emulator For Windows…   Click Here

Buddy: Wow That Really Works! Thanks!

Godhc: Glad to help you, Adieu!

CPU Information-Linux

Q:Help I need to find some details regarding my system…How do i do that?  and i use Linux/Ubuntu

Yes..We all come across such situations..here are some commands that you can enter in the Linux Terminal and get what you want.

_______________________________________________________________

1.I Want to know What CPU i have and other details like What flags it has?

Type this:

cat   /proc/cpuinfo

*Note You can use the Flags to see if you have  “lm” i.e long mode,which tells you whether you’r system is capable of handaling 64 bit OS..yeah they are getting popular now…*

_______________________________________________________________

2.Hey Even i want to  know about my Memory

cat  /proc/meminfo


*Click To View Larger Size.

_______________________________________________________________

3.I Want to know Everything about my System..all the hardwares,interfaces..?

lspci

  • If You  are familiar …in certain cases you get large list of items/details, to scroll through them easily,use the pipe symbol.

use     | less to get fewer details ..which u can scroll through

example:  lspci  | less

  • If You Want to search for some term then use | grep  Whatyouwanttofind

example: lspci  grep VGA