I am trying to run a query on the tuning lab and not the batch optimizer. and for some
odd reason sql optimizer closes. Once i click on optimize button, it applies all the
hints and give me all the alternative query. But when i go and click on EXECUTE ALL.
SQL optimizer closed and give me the below error…first error is the screenshot1
and the screenshot2 is another error that i get after screenshot1. I thought it was
running out of memory on my laptop. But then i opened up task manager. and the load
look fine. I have 3gigs of ram on my laptop. Any reason why this is happenin
and how can i fix it ?? As i mentioned i only to get the ALTERNATIVE query part
and then when i try to execute all of them to get the timing and other stats…it
closes on me…any help will be greatful.