BE SHARING

Hocine Mechara

SQL-Server: What are VLF’s and why should I care about them?

16.04.2024 by Hocine Mechara

Introduction: What are VLF’s? In SQL-Server, the transaction log is divided into several logical units called virtual log files (VLF). The amount of virtual log files and their size are managed automatically by the database engine. The database engine adds(…)

Database management

SQL Server: Manage large data ranges using partitioning

26.02.2024 by Hocine Mechara

Introduction: When it comes to moving ranges of data with many rows across different tables in SQL-Server, the partitioning functionality of SQL-Server can provide a good solution for manageability and performance optimizing. In this blog we will look at the(…)