blogging
As a software developer, you’ll likely work with one or multiple database systems that integrate with your applications. One of these database systems is Microsoft’s SQL Server. In this post, I’d like to list some tasks you might consider to reduce headaches and make your work more
MS SQL
[Updated on 2024-06-30 based on feedback from comments] A while ago, I blogged about how to efficiently update millions of records in a SQL table, today I’d like to show you a simple trick to do the same when deleting millions of records in a SQL table. The idea
MS SQL
This is a copy of the post that used to exist here for which I got some complaints since some people where still trying to read it when looking at an answer I wrote on StackOverflow a few years ago and the page was not there anymore. The above is