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

Performance

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

A note about impostor syndrome

Impostor syndrome is when a person doubts their accomplishments, feels that they don’t deserve it, or think that their achievements (a promotion, a raise, etc.) are the result of luck. The impostor syndrome can affect anyone, especially women and minorities who fear they owe their accomplishments to affirmative action.
Ricardo Sanchez 10 Feb 2019

Parallelism. Using Parallel.For and ConcurrentBag.

Parallelism refers to the technique of running multiple calculations at the same time to speed up a computer program. Historically, this has been a complicated thing to write requiring a developer to do complicated coding including low-level manipulation of threads and locks. A program will generally run faster if you
Ricardo Sanchez 15 Jan 2019

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