Tag: minimal-logging

Links and Resources from How to Architect Successful Database Changes

By Kendra Little on November 6, 2019

Category: devops-automation , sql-server

Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day.

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.

Minimal-Logging

Tag: minimal-logging

Links and Resources from How to Architect Successful Database Changes

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