InSystem Design SimplifiedbyVijay SRJHow ALTER TABLE statement in MySQL got faster in version 8Uber recently migrated its MySQL database from version 5.7 to 8.0 . One of the significant features of this version is ALTER TABLE command…Oct 16
Chidambaram A MManaging Tables in Snowflake: Understanding When to Use RENAME TO vs SWAP WITHIn Snowflake, managing tables effectively involves knowing when to use specific SQL commands like RENAME TO and SWAP WITH. These commands…Jul 5
Aditya BankarPower of ALTER TABLE in SQL:In the ever-evolving landscape of databases, the ability to adapt and modify tables is crucial. SQL’s `ALTER TABLE` statement is a powerful…Dec 24, 2023Dec 24, 2023
Sullyvan NunesAvoiding downtime altering large tablesImagine that you have a Postgres 9.5 table over 30M rows and about 30 GB, and then accidentally you add a column with the wrong type.Mar 25, 2020Mar 25, 2020
Amulya Kumar pandaADD and DROP a column in the ALTER TABLE in a snowflake.ALTER TABLE: Support for IF [NOT] EXISTS with ADD COLUMN and DROP COLUMN.Oct 25, 2023Oct 25, 2023
InSystem Design SimplifiedbyVijay SRJHow ALTER TABLE statement in MySQL got faster in version 8Uber recently migrated its MySQL database from version 5.7 to 8.0 . One of the significant features of this version is ALTER TABLE command…Oct 16
Chidambaram A MManaging Tables in Snowflake: Understanding When to Use RENAME TO vs SWAP WITHIn Snowflake, managing tables effectively involves knowing when to use specific SQL commands like RENAME TO and SWAP WITH. These commands…Jul 5
Aditya BankarPower of ALTER TABLE in SQL:In the ever-evolving landscape of databases, the ability to adapt and modify tables is crucial. SQL’s `ALTER TABLE` statement is a powerful…Dec 24, 2023
Sullyvan NunesAvoiding downtime altering large tablesImagine that you have a Postgres 9.5 table over 30M rows and about 30 GB, and then accidentally you add a column with the wrong type.Mar 25, 2020
Amulya Kumar pandaADD and DROP a column in the ALTER TABLE in a snowflake.ALTER TABLE: Support for IF [NOT] EXISTS with ADD COLUMN and DROP COLUMN.Oct 25, 2023
Jasmine AbtahiUnderstanding the “GO” Command in SQL ServerWhen writing SQL queries in SQL Server, you may have come across the “GO” command. But why do we use it? What purpose does it serve, and…Sep 30
Dhruv SinghalEfficiently Alter Table Column Data Types in SQL Server with Large DatasetsGreetings and welcome to this tutorial! 🌟 Our aim is to guide you through the process of efficiently changing column data types for a…Aug 10, 20231
InEngineering @ ChargebeebyAdithya K SEliminating MySQL replication lag for schema changesModifying schema for large MySQL datasets leads to heavy replication lag. See how we got beyond that.Nov 25, 20202
