Monthly Archives: August 2021

Hibernate Best Practices – using sequences for bulk inserts

For many database tables, an auto increment column is used for the primary key. This is fine for inserting single values, but if you want to bulk insert hundreds or thousands of values and you need to refer to the … Continue reading

Posted in Hibernate, Java, Uncategorized | Tagged , | Leave a comment

Freeing space in SQL Server

When running my local development environment, I frequently need to free up space in SQL Server. How is this done? Firstly, ff there are databases you don’t need, delete them with: ALTER DATABASE your_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE DROP … Continue reading

Posted in SQL Server | Tagged , | Leave a comment