Biztalk server : Dehydration and Rehydration

Dehydration :-
==========
Dehydration is the process of storing orchestration state in the message box through object form called dehydration.

Rehydration :-
=========
It is the process of restoring the orchestration state back to its original position from object form .

BizTalk Server Knowledge Base Articles

Below link has few knowledge base articles  and hot fixes . These articles would help us when dealing with any performance related or unexpected errors
 

http://msdn.microsoft.com/en-US/library/cc983851(v=BTS.10).aspx

Ordered Message Delivery in BizTalk Server

Microsoft has published an article on ordered message delivery. Good to go through ....

http://msdn.microsoft.com/en-us/library/bb851740.aspx

ASP.Net : What is webgardening

Web gardening enables multiple worker processes to run at the same time. However, you should note that all processes will have their own copy of application state, in-process session state, ASP.NET cache, static data, and all that is needed to run applications.

When the Web garden mode is enabled, the ASP.NET ISAPI launches as many worker processes as there are CPUs, each a full clone of the next (and each affinitized with the corresponding CPU). To balance the workload, incoming requests are partitioned among running processes in a round-robin manner. Worker processes get recycled as in the single processor case. Note that ASP.NET inherits any CPU usage restriction from the operating system and doesn’t include any custom semantics for doing this.

SQL Query : Getting Nth highest salary from the employee

In any interview these days , everybody would be facing this question some time in their career. Below is the easy way to get the Nth highest salary among the employee salaries

SELECT TOP 1 SALARY FROM (SELECT DISTINCT TOP N SALARY
FROM EMPLOYEE ORDER BY SALARY DESC)SAL
ORDER BY SALARY

Place the value in place of N.

SQL Server : INTERSECT

-Returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand

-It almost works like INNER JOIN

-Difference is INTERSECT treats two NULL values are same whereas INNER JOIN treats two NULL values are different