How to Alter a Datatype With (Almost) No Downtime

preview_player
Показать описание
  1. Brent Ozar Unlimited
Рекомендации по теме
Alter or Change 0:06:46

Alter or Change DataType of a Column in SQL Server

How to Alter 0:38:40

How to Alter a Datatype With (Almost) No Downtime

MySQL | How 0:05:26

MySQL | How to change the datatype of a column to date datatype

Alter column size 0:04:32

Alter column size and Data Type in SQL Server

Alter Column Data 0:01:52

Alter Column Data Type in SQL

Practical MySQL 01-17 0:01:17

Practical MySQL 01-17 Alter table structure: Change datatype

How do I 0:02:17

How do I change the data type for a column in MySQL

MS SQL Server 0:14:41

MS SQL Server 2019 | How to Alter Table for Naming and Data type changes

SqlDBA Batch55 Class10 1:03:17

SqlDBA Batch55 Class10 Creating Tables, Inserting Records & Filtering Data || Contact +91 990259...

How to Change 0:25:23

How to Change the datatype of columns in MYSQL table

Change datatype of 0:04:14

Change datatype of existing column in mysql | How to change datatype in sql

How to alter/change 0:05:23

How to alter/change datatype of any column in sql | Postgresql | Mysql | Oracle | Basic sql

How to alter 0:07:22

How to alter table(change column datatype with USING keyword) in PostgreSQL

How to Change 0:03:17

How to Change Data Type of Column

Table Rename ,Column 0:04:11

Table Rename ,Column Rename and Change Data type Column in Database PostgreSQL.

ORACLE SQL AND 0:13:18

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO CHANGE DATATYPE IN ORACLE SQL?

19. Change Column 0:02:55

19. Change Column Datatype in Dataframe | Using PySpark

CHANGE COLUMN DTYPE 0:13:40

CHANGE COLUMN DTYPE | How to change the datatype of a column in Pandas (2020)

How to use 0:02:35

How to use Alter command to change datatype size?

How to Alter 0:01:06

How to Alter Column Datatype in PostgreSQL

SQL Alter Statement 0:05:05

SQL Alter Statement How to change exisiting column datatype in sql server

Lesson #15 0:02:52

Lesson #15 How to alter the datatype in TSQL of a column

ALTER TABLE; Change 0:04:19

ALTER TABLE; Change data type of column in existing table; MySQL phpMyadmin MariaDB; command line

How to change 0:00:51

How to change name and datatype of column of table in SQL

Комментарии
Автор

This is going to be game changer. We have been spending weeks in migrating VLT table column from int to bigint. Thanks to you and SphagettiDBA.

DevBethanasamy
Автор

Brent it is so awesome to watch your videos and see how do you like what you do. I am mssql developer and something I know what you saying, sometime no but I always enjoy your presentation and enthusiasm.

alexnevidimkins
Автор

Awesome, I had this problem precisely a month ago on a primary key. Fortunately, at that time I could delete old records as only the last 6 months' data is required, and then reseeded the identity. I wrote a job to warn me if it approached the max int again. Unfortunately, we are still on SQL 2012 :( I will definitely revisit this when we upgrade one day.

ValleyofEndar
Автор

alter table dbo.posts alter column OwnerUserID bigint with (online = on)
also works. Not optimal, but to complete the picture. Locking seems different during operation. As mentioned ONLINE is an enterprise feature

wfvdijk
Автор

Is there a way to make this work if you go from varchar to nvarchar?

prebenhuybrechts