Community

SQL Server – Blocking a Truncate

(blobeater) 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?