Running-Out-of-Ints

Tag: running-out-of-ints

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

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.

Continue reading