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 ...

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 ...

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 ...

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 ...

The new In-Memory OLTP feature introduces memory-optimized tables and natively compiled stored procedures in SQL Server 2014, to optimize performance and scalability of OLTP workloads. To benefit from ...

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 ...