Francis Kioko (10/24/2013)
When i set the Max memory setting to anything below this value the query executes in less than 2 secs.
i dont think reducing memory can boost the performance.
the execution time in 4 min (with more mem) and 2 secs (with less memory) is it a regular pattern ? i doubt here though
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)