Tag: MS SQL
-
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 enjoyable. Microsoft SQL Server is a fantastic relational…
-
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 is the same, you don’t want…
-
How to: Configure SQL Express to accept remote connections
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 an exact replica of the original post,…