tubeshowcase●1,671,415 videos♡ My collection 0
← Learn to Code

Learn to Code15:17

How Resumable Indexes in SQL Server 2019 Makes Your Job Easier | Data Exposed: MVP Edition

Microsoft Developer ↗

From the creator

Microsoft continues to push the envelope on feature capabilities with every release of SQL Server. One of the more prominent features that was released with Microsoft SQL Server 2019, is the ability to resume or throttle certain index operations. Have you ever wanted to just stop and then resume an index operation picking up where it left off? Now you can! This feature alone magnifies the data professionals' ability to have deeper granular control on how index operations affect their ecosystem as well as their work-life balance. In this episode, John Morehouse gives a high-level overview of how this feature works and how it can be applied seamlessly to your environment. 0:00 Introduction 0:53 What is a resumable index? 1:50 Time commitment 3:09 Set up 3:56 Feature benefits 5:44 Demo 12:05 Denny Cherry & Associates Services ✔️ Resources: Guidelines for online index operations: https://docs.microsoft.com/sql/relational-databases/indexes/guidelines-for-online-index-operations?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner Denny Cherry & Associates: https://www.dcac.com?WT.mc_id=dataexposed-c9-niner About John Morehouse: John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of

Published 2020-08-04 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code