I had a performance issue with SQL Server while getting the datausing .net. so created Index on two fields yesterday and the reports were running fast, but today I see that they have slowed again, what could be the reason and how to resolve this.
Thanks for any help or tips...
check amount data inserted & deleted after index creation
check index fragmentation level
update your statistics
also check the waittype coming during running report query
Rohit Garg (My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.