SQL Server Table partitioning – DOs and DON’Ts

Автор: SQLBits

Загружено: 2021-05-11

Просмотров: 30479

Описание:

When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
Speaker: Margarita Naumova https://SQLbits.com/speakers/Margarit...

http://SQLbits.com/Sessions/SQL_Serve...
Tags: Optimising,Developing,Managing,On-prem,performance,partitioning,indexing,Database engine,optimizing

SQL Server Table partitioning – DOs and DON’Ts

Доступные форматы для скачивания:

Скачать видео mp4

Информация по загрузке:

Скачать аудио mp3

Похожие видео

Why You Need Query Store

Why You Need Query Store

Fundamentals of Stored Procedures

Fundamentals of Stored Procedures

SQL Table Partitioning (Visually Explained) | Optimize Big Table Performance | #SQL Course 42

SQL Table Partitioning (Visually Explained) | Optimize Big Table Performance | #SQL Course 42

Dealing with Very Large Tables in SQL Server

Dealing with Very Large Tables in SQL Server

Сальников Андрей, DataEgret, Казань - СЕКЦИОНИРОВАНИЕ ТАБЛИЦ. КАК РАБОТАЕТ И КАК ПРИМЕНЯТЬ

Сальников Андрей, DataEgret, Казань - СЕКЦИОНИРОВАНИЕ ТАБЛИЦ. КАК РАБОТАЕТ И КАК ПРИМЕНЯТЬ

Deadlocks: Lets Do One, Understand It, and Fix It

Deadlocks: Lets Do One, Understand It, and Fix It

Senior DBA Class - Index Maintenance for Enterprise Environments

Senior DBA Class - Index Maintenance for Enterprise Environments

Maximizing Database Performance With Isolation Levels

Maximizing Database Performance With Isolation Levels

SQL Query Optimization. Why is it so hard to get right?

SQL Query Optimization. Why is it so hard to get right?

4 часа Шопена для обучения, концентрации и релаксации

4 часа Шопена для обучения, концентрации и релаксации

Query Store Best Practices

Query Store Best Practices

Jazz & Soulful R&B smooth Grooves Relaxing instrumental Playlist /Focus/study

Jazz & Soulful R&B smooth Grooves Relaxing instrumental Playlist /Focus/study

How to get started with MLOps in Azure Databricks

How to get started with MLOps in Azure Databricks

Kubernetes — Простым Языком на Понятном Примере

Kubernetes — Простым Языком на Понятном Примере

10 Query Tuning Techniques Every SQL Programmer Should Know

10 Query Tuning Techniques Every SQL Programmer Should Know

CS50 SQL - Lecture 5 - Optimizing

CS50 SQL - Lecture 5 - Optimizing

Brent Ozar_Watch Brent Tune Queries

Brent Ozar_Watch Brent Tune Queries

Фрагментация: объяснение за 20 минут

Фрагментация: объяснение за 20 минут

SQL Stored Procedure (Visually Explained) | Comprehensive Guide | #SQL Course 33

SQL Stored Procedure (Visually Explained) | Comprehensive Guide | #SQL Course 33

SQL Server Data Partitioning by Vijay Reddy

SQL Server Data Partitioning by Vijay Reddy