Tag: microsoft

Execute SQL Query On Single Processor

Leave a comment

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

8 Comments

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

Leave a comment

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 →