March 25, 2016 at 8:57 pm
Hi all,
Recently i any idea for fixing this ?
March 25, 2016 at 9:01 pm
Please post the table structure,your update query and the index definition that you added.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 26, 2016 at 8:08 am
And the execution plan for the update query.
There's no way to simply guess what is happening. You have to gather metrics to understand and the one metric that describes how queries are resolved is the execution plan.
"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
March 28, 2016 at 5:09 am
The question, as it's been asked, has a very simple answer:
remove that column you added recently from the index - everything should be back where it was before.
_____________
Code for TallyGenerator
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply