Thanks, Lutz.

I hope I did it right this time.

---Updatetime can be null then current datetime of the query runtime should be used

--Create the Data Table

CREATE TABLE Incidents (

Incident_ID int...

Rebooted the machine twice and it worked this time:)

Thanks for all the help

I was reading somewhere that I should enable lock pages memory , reboot and then enable the AWE.

I may not have followed this exact order.

Should I try that?

How can I change the run value?

It is checked in SSMS. I have boother the machine before.

Is it because of the rights issue?

I Granted "Lock Pages in Memory"...

Here is a screen shot attached

Yes I have done this before manually from SSMS and then from query window.

I just did it again now.

AWE is checked in SSMS

Here is the result after running your query

Configuration...

Buffer cache is 99.8%

Procedure cache is 89%

This is what I get

Memory through AWE

--------------------

0

How can I determine and make sure that 25GB is available for the SQL server?

I was expecting that Target Server memory would be 25GB (1024*1024*25=26214400)

not 1.55 GB...