Tips To Increase Performance of Store Procedure

1. NOCOUNT
Normally if you perform query in Query Analyzer, it will return row count information in output. By default this NOCOUNT option is tuning OFF, it is advised to SET NOCOUNT ON to save overhead and increase performance.

2. NOLOCK
This will not lock your table and increase performance.

3. Return Value
If you are querying about single value, to best is just return value to save the overhead and performance.

Posted via web from Ervin Ter’s posterous

Tags:

Disconnected With Outside World

Recently, I just too busy with too many things. First of all, I would like to appologize for everyone that I have no time to update my blog, twitter, facebook, MSN, GTalk, Gmail and many mores.

Just for your information, I resigned my previous job with NGA and now I am in my new company. My new company situated in Damansara Height, which is near HP building. Here I got no connection to outside world such as MSN, GTalk, Facebook, Twitter and so on. At the very beginning I feel like end of the world, but slowly get used to it.

Other than job changing, I also change my living area. Now I already move to my new house where situated in Setia Alam near Bukit Raja. Feel free to visit my new house.

I will try to update more in futures as my new house has no internet connectivity yet. Imagine how nightmare the life without internet.

Cheer!

Posted via web from Ervin Ter’s posterous

Microsoft Application Architecture Guide 2nd Edition from Patterns & Practices

Microsoft Patterns & Practices released the 2nd edition of their Microsoft Application Architecture Guide. You can read it for free via HTML or purchase a copy from Amazon.

If you are using Microsoft development technology for example, Visual Studio as your development tool in your working or your part time job, you probably hear about Enterprise Library. It is best practice framework for building enterprise application for either Web or Winform application.

There is release on 2nd edition of their Microsoft Application Architecture Guide. Check it out.

Posted via web from Ervin Ter’s posterous

Tags:

Google Chrome OS To Launch Within A Week

Google’s Chrome OS project, first announced in July, will become available for download within a week, we’ve heard from a reliable source. Google previously said to expect an early version of the OS in the fall.

Another OS war between Windows 7 and Google Chrome OS. Anyhow, I will see how can Google Chrome OS change computing.

Posted via web from Ervin Ter’s posterous

Tags:

AirAsia Free Seats are still available!!

Faster grab your seat before it is finish.

Posted via web from Ervin Ter’s posterous

ASP.NET MVC DropDownList and HTML Attributes « Rob Conery

I setup the Controller to creaet a SelectList, like so:

NorthwindDataContext db = new NorthwindDataContext();  var categories = from c in db.Categories select c;  ViewData["CategoryID"] = new SelectList(categories, "CategoryID", "CategoryName");  

Then, in my View I rendered the DropDownList:

=Html.DropDownList("CategoryID",ViewData["CategoryID"])%>

This is very important if you are using Html.DropDownList in MVC

Posted via web from Ervin Ter’s posterous

Tags:

My new keyboard and mouse

Posted via email from Ervin Ter’s posterous

The Go Programming Language

Google language?

Posted via web from Ervin Ter’s posterous