Blog Post

SQL Server – Blocking a Truncate

,

The truncate option is fast and efficient but did you know that it takes a certain lock where you could actually be blocked? What am I talking about? When you issue a truncate it takes a Sch-M lock and it … Continue reading

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating