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!

Remote Desktop Connect To Windows From Mac

This article presents a straightforward solution to access your windows Content on Your Macintosh PC!!!

So I (This means you-who is reading this article) may have one or more of the below questions in mind: 😀

  1. I some how want to access my remote Windows machine (windows xp,vista,7,8) on my MAC
  2. I have a huge 27′ Apple BOOTCAMP just to run few programs of windows on mac .
  3. Uh!!! I don’t want to fight with my MAC anymore!!
  4. Continue reading

Simple ASP.NET Code To Put Data Into Your MS Access DB

An asp.net Web Code For You to take user inputs and store it on to your Ms Access Database!Be Sure to Create it before and take care when you form the ConnectionString !!! That’s Very Important!



Default.aspx:

<%@ Page Title=”Home Page” Language=”C#” MasterPageFile=”~/Site.master” AutoEventWireup=”true”

CodeBehind=”Default.aspx.cs” Inherits=”WebApplication1._Default” %>

<asp:Content ID=”HeaderContent” runat=”server” ContentPlaceHolderID=”HeadContent”> Continue reading

Microsoft Live Messenger For IPhone

Presenting the cool looking Microsoft Live Messenger for Iphone:

  • Integrates All your social Contacts in one place.
  • Streams all the updates From Facebook and other Social Networks.
  • One Stop to check all your mails,chats,Social Streams.
  • Superbly organised.
  • A Special auto completion of email when you type your login id!
  • Similar interface of the hotmail page.

Continue reading

Microsoft OneNote

OneNote:

This a Free App (For Time being) From Microsoft For Iphone

You might be familiar with Evernote and Springpad that have rocked this segment!

Why use this:

  • Nice fluid flow UI
  • looks really appealing
  • Upload to your Sky Drive directly
  • Take pictures,audio and get them online and have them in Sync among many computers
  • You have a similar Desktop Client too.

Continue reading