ElijahE (10/24/2013)
Adding a clustered index fixed it. After adding the clustered index on those two columns the query returns in 0 seconds.
it will actually it must be . try to create indexes to support your quesries.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)