Not sure if you have a query or an index problem? Before trying to improve SQL performance, watch this series of videos. I explain how to check query performance in SQL Server and which problems you can solve by changing queries or indexes.