This article answers the user query, i.e. How to open SQL Server transaction log file. If you have a similar query, then don’t worry in this article we are going to discuss how to open transaction ...

Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

This project is a an analyzer of the SQL server 200, 2005, 2008 Trans action logs. It requires: -SQL server 2000, 2005 or 2008 -You must build a test table that contains every SQL server data type ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

Learn about the SQL Server XTP Transaction Log performance object, which contains counters related to In-Memory OLTP transaction log activity in SQL Server. The SQL Server XTP Transaction Log ...

This post was authored by Liang Yang, Principal Performance Engineer on the Hyper-V team and Jos de Bruijn, Senior Program Manager on the SQL Server team. With Windows Server 2016, Microsoft has ...