Very interesting approach and a well written article! I've been looking for scalable and redundant SSRS farm alternatives using Standard Edition to save on licensing costs vs. Enterprise Edition.

I don't believe the AWE option makes any difference on a 64-bit system so that shouldn't be an issue.

See these two articles for more explanation:

http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-530-awe-must-be-enabled-on-64-bit-servers/

Since it's a VMware...

If I understand what you're asking for correctly, this should do it:

SELECT C.Name, SUM(P.Total), SUM(O.Total)

FROM Customer AS C

LEFT OUTER JOIN [Order] AS O

ON O.CustomerID = C.CustomerID

...

Scripting this out from msdb is the way to go. All the information you need to generate a script for this is stored in msdb already. The link below has...

No need to restart the server, it will take effect immediately. If you have Task Manager up on the Server while you do it, you can see the results almost...

Hi nagkarjun1,

The Max Server Memory setting only controls the size of the Buffer Pool and not the entire memory used by SQL Server.

Taken from: http://msdn.microsoft.com/en-us/library/ms180797(v=sql.105).aspx

SQL Server as a...

The "reader" name is definitely misleading. This may be stating the obvious, but to get around this I've granted the SQLAgentReaderRole role and explicitly denied EXECUTE on add job sprocs...