Enable Large Memory Support in SQL Server

To enable SQL Server to utilize all available memory more than 3GB you need to make sure that the following options comply,


1. /AWE is enable in boot.ini file

2. /PAE is enable in boot.ini file

3. AWE is enabled in SQL Server, and make sure from the server logs that it is enabled while server starts....

4. Enabled the Lock Pages in Memory

Also this is recommended to put max memory value to avoid OS to go under memory pressure, Suggested Max Memory Settings for SQL Server 2005/2008

Multicolumn Subquery in SQL Server

In Oracle and Other databases, there is a support of multicolumn subqueries like,

select * from ATable where (Alpha, Beta) in (select alpha, beta from BTable)

Same can be done by exists clause in SQL Server like

Select * from ATable A where Exists (Select 1 from BTable B where B.Alpha = A.Alpha and B.Beta = A.Beta)