Tag: transaction log

TSQL Tuesday #77 – Favorite SQL Server Feature: SQL Server Logging

[callout]It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|Twitter) started. This month’s episode is hosted by Jens Vestergaard (blog | Twitter). The topic: Favorite SQL Server Feature. And my favorite SQL Server feature is not any of the latest and greatest ones. That might come as a surprise but at the end of the blog […]

In-Memory OLTP in SQL Server: Logging Comparison with Disk-Based Tables

In a previous blog post, I talked about Partition-Level Online Index Operations in SQL Server 2014 and how it affects high availability and disaster recovery. With more features being added in every new version of SQL Server, it’s important to understand how its implementation will affect your overall objectives. One feature that got a lot […]