Deleting rows from SQL Server database table is not as simple as it sounds.
The ‘straight forward’ delete – go delete, no matter what!
Yes, there is the DELETE statement:
?View Code TSQLDELETE table_1 WHERE ColumnName = ‘some_value’
What is the problem with that?
There are several problems:
transactions and logging
locking and concurrency
parallelism, if present
So, it depends how
Continue reading […] The ‘smart’ delete […]