Transaction logs in SQL Server play a critical role in database recovery and integrity. However, the size of these logs can significantly impact the performance of your database.

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

We normally think of distributed transactions just within the scope of a SQL Server transaction. However, you can also put things like file system access by a .NET application within a distributed ...

Windows Server 2016 and SQL Server 2016: Leveraging Hyper-V large-scale VM performance for in-memory transaction processing This post was authored by Liang Yang, Principal Performance Engineer on the ...

Troubleshoots the issue where transaction log file grows continuously for databases with In-Memory OLTP enabled in SQL Server 2022. If you restart the SQL Server instance, you might notice the ...

WRITELOG —When a SQL Server session waits on the WRITELOG wait type, it’s waiting to write the contents of the log cache (user delete/update/inserts operations) to the disk where the transaction log ...