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 […]
Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.
Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured
Continue reading […] How to query currently running SQL Server Agent jobs […]