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!!

Microsoft Internship Hyderabad Period

Internship at Microsoft Hyderabad Starts and Will Continue For 8 Weeks Yaay!!

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”>

Windows Home Server 2011

The Windows Home Server-2011 is Going to be launched soon Its Codenamed the Vail …

Here is a Quick Demonstration Of It:

 

Features:

1. Multi PC Backup
2. New Windows 7 Interface! -phew after 2008 something more current generation,thanks Microsoft