Skip to content
(AI Gen) INT → BIGINT, a SQL Story episode artwork

Nov 22, 2024 10 min

(AI Gen) INT → BIGINT, a SQL Story

from Tilt Engineering Hosted by Matthew Preciado

Running out of range on a primary key in SQL Server is a ticking time bomb, especially for high-traffic production tables. This article dives deep into the process of migrating a primary key column from INT to BIGINT, tackling challenges like constraints, clustered indexes, and data synchronization. Learn the tested strategies, performance tweaks, and lessons from a real-world scenario involving 650 million rows—ensuring scalability and reliability for your database. Perfect for engineers navigating similar database dilemmas.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

(AI Gen) INT → BIGINT, a SQL Story

0:00 10:00

No transcript yet.

Requests help us decide what to transcribe next.

DevOps In Agile Way Pawel Piwosz "DevOps in Agile Way" is a captivating podcast that immerses listeners in the dynamic realm of DevOps, engineering practices, value streams, Clouds, AWS, Agile methodologies, and a myriad of other captivating subjects. Through engaging conversations and expert insights, this podcast serves as a bridge between all interested parties, fostering collaboration and enabling efficient software delivery. Join me on a deep dive into the fascinating intricacies of DevOps, where I explore cutting-edge tools, share best practices, and offer real-world anecdotes from industry experts. From continuous integration and deployment pipelines to automation of infrastructure and cloud-native architectures, I unravel the latest trends and strategies that empower organizations to achieve swift and dependable software delivery. Our exploration extends to the Agile methodology, highlighting its seamless integration with DevOps practices and its pivotal role in driving iterative development, cr EEBO Metrics Dinker Charak & Sachin Dharmapurikar EEBO Metrics create a line of sight from engineering excellence to business outcomes. It is a framework that establishes a correlation between engineering excellence and business outcomes through fully-modeled performance indicators that cover software development and deployment in production on one side and business outcomes on the other.This channel was earlier named LUSWIG (Let Us See Where It Goes). We used to start with a topic, mostly technology-oriented, with the idea, ’Let Us See Where It Goes!’Platforms• Apple Podcast: https://podcasts.apple.com/in/podcast/luswig-let-us-see-where-it-goes/id1685928302• Spotify: https://open.spotify.com/show/4I4necoezPS7LakktKAZmv• YouTube: https://www.youtube.com/@eebo-metricsAbout:• Views expressed are our own and do not necessarily reflect that of our employer• Dinker Charak: https://www.linkedin.com/in/dinkercharak - https://www.ddiinnxx.com• Sachin Dharmapurikar: https://www.linkedin.com/in/dharmapurikar The Civil Engineering Podcast Anthony Fasano, PE, AEC PM, F. ASCE and James Taylor, JR., P.E. The Civil Engineering Podcast provides engineering career advice and success stories specifically for civil engineers. Civil engineers Anthony Fasano, PE and Christian Knutson, PE host the show and showcase civil engineering projects and professional The AEC Leadership Podcast Anthony Fasano, P.E., AEC PM, F. ASCE & Rebecca Swabey, P. Eng Leadership in architecture, engineering and construction comes with its own set of challenges, and technical leaders at all stages of their career need support and guidance. The AEC Leadership Podcast (AECLP) is dedicated to helping engineering leaders of all experience levels navigate these challenges. With a diverse audience of AEC professionals across various disciplines, The AECLP provides valuable insights and practical advice.

Frequently asked questions

How long is this episode of Tilt Engineering?

This episode is 10 minutes long.

When was this Tilt Engineering episode published?

This episode was published on November 22, 2024.

Can I download this Tilt Engineering episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.