I was just wondering. I have been hitting a database pretty hard for the last few days and wondered if ..... like Crystal Reports....does SSMS allow you to use the SAVED DATA or the CACHED DATA in memory from the last time the Report/Query in this case was run.
I just pulled 1 million records in 12 minutes. Now I have to limit the records again in SSMS. I was wondering if I can use what was cached to filter the records out again this time with what I had already hit.....? Is this possible.