High Water Mark in Sql Server
What is High Water Mark in SQL and why it is used with Truncate statement?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Oct 11, 2011, 12:25 AM
High Water Mark is max. space a particular table occupied till that point. that doesn't mean that one cannot insert records more than a HWM. Once HWM is crossed a new HWM is set for a table.
And In case of truncate it has to reset to zero thats why its used with truncate.
Thanx,
Pravin.