Sean Lange (4/11/2016)
skb 44459 (4/11/2016)
Can you post execution plans?
- Execution plan says. Query Cost 'Relative to batch) : 50%
Stating the relative cost of the batch when compared to the contents of the actual execution plan is like asking somebody to read you a book and you only read the title. You need to capture the execution plan and post it. It has tons of valuable information. Take a peek at this article for things you should post for performance problems. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]
I don't even think that's the books title. More like the genre & nothing else.
There just isn't enough with simple query listings to go on to make suggestions for performance improvement.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning