Ricardo Sanchez
  • Home
  • Español
  • YouTube
  • About
  • Contact
Sign in Subscribe

SQL

How to Prevent Identity Column Exhaustion in SQL Server

How to Prevent Identity Column Exhaustion in SQL Server

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
Ricardo Sanchez 04 Jun 2024

How to (efficiently) delete millions of records in a SQL table

[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
Ricardo Sanchez 20 Jan 2023

How to (efficiently) update millions of records in a SQL table

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
Ricardo Sanchez 11 Sep 2020

Subscribe to Ricardo Sanchez

Don't miss out on the latest news. Sign up now to get access to the library of members-only articles.
  • Support our Writing
  • Connect
  • Sign up
  • Disclaimer
  • Privacy
  • Terms
Ricardo Sanchez © 2025. Powered by Ghost
Mastodon