Memory usage for excel wouldn't pass 500mb (I have 16 GB) before crashing. I established 8 GB as maximum allowed in 'Data Cache Management Options'. What can I do? My first query has around 7 million rows and the second one just 500 rows. Is there a better approach to this?
Bookmarks