CPU Config- Intel i7(3rd generation)-64 bit,Windows 7, 6GB RAM. But it runs perfectly smooth on computers having till i5(64 bit processor) and also on other 32 bit computers. How do I improve it??
Perhaps might be this post http://www.sql-server-performance.com/forum/threads/sql-2008-slow-queries.33962/ is similar to your case , please check it and if still persists kindly let me know