SQL Server Table partitioning – DOs and DON’Ts

SQLBits May 11, 2021
Video Thumbnail
SQLBits Logo

SQLBits

@sqlbits

About

Introducing SQLBits... a data professionals’ conference with a difference. SQLBits is that rare thing - a conference that doesn’t feel like a conference. Forget never-ending PowerPoints, dry lectures, or predictable catering, this UK-based event has grown from an industry secret to a dynamic global phenomenon. Created by data professionals for other data professionals, it's a conference designed and delivered by the UK Data community it aims to serve. Unlike other conferences, it’s famously friendly and fun - with education, knowledge sharing, and community at its core. Since its inception in 2007, SQLBits has become the largest data conference in the world; providing delegates with access to the sector’s best experts and thinkers - including those behind the Microsoft Data Platform.

Video Description

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/Margarita_Naumova http://SQLbits.com/Sessions/SQL_Server_Table_partitioning__DOs_and_DON_Ts Tags: Optimising,Developing,Managing,On-prem,performance,partitioning,indexing,Database engine,optimizing