Tag: transaction-log

WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)

on March 2, 2017

When you’re a Junior DBA, it’s really hard to take in all the information out there.

Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. This is a foundational concept that helps you understand how SQL Server works.

Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)

By Kendra Little on August 4, 2016

Category: database-administration , sql-server

Tags: alter-table , dear-sql-dba , error-8115 , identity , minimal-logging , msg-8115 , running-out-of-ints , schema-changes , size-of-data-operation , transaction-log

You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.

Transaction-Log

Tag: transaction-log

WAL: The concept that makes recovery models & backups make sense (Dear SQL DBA Episode 32)

Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)