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
SQL
You need to update one or more columns in a table with millions of records with data from another table, what’s a good way of going this with low risk and in an optimized way? One of my favorite ways of dealing with millions of records in a table