Timming out sp (>15 secs), maybe lack of index/stats maintenance
This seems to run in under a second for me, though the customer sent a screen-shot of the front-end app timing out after 15 seconds.
Any help please
Thanks Aaron, looks like it may have been a front-end code issue after all.
When I ran into this situation with a stored procedure, it turned out that the application (which used Entity Framework) was getting a different plan than what I was getting through SSMS due to a different in the default SET options for each. I recompiled the stored procedure and the application started getting results as quickly as SSMS.