Skip Main Navigation
Eventbrite
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content
This event has ended.

Actions Panel

Oct 04

Joe Obbish – Clustered Columnstore For Performance

Action Man Joe Obbish brings an incredible amount of in-depth knowledge about clustered column store performance.

When and where

Date and time

Fri, October 4, 2019, 9:00 AM – 5:00 PM EDT

Location

Courtyard by Marriott New York Manhattan/Times Square 114 West 40th Street Meeting Room A+B New York, NY 10018

Map and directions

How to get there

Refund Policy

No Refunds

About this event

This is a precon for SQL Saturday NYC, on October 5th.

The precon takes place the Friday before, on October, 4th.

Details:

Clustered columnstore indexes can be a great solution for data warehouse workloads, but there's not a lot of advanced training or detailed documentation out there. It's easy to feel all alone when you want a second opinion or run into a problem with query performance or data loading that you don't know how to solve.

In this full day session, I'll teach you the most important things I know about clustered columnstore indexes. Specifically, I'll teach you how to make the right choices with your schema, data loads, query tuning, and columnstore maintenance. All of these lessons have been learned the hard way with 4 TB of production data on large, 96+ core servers. Material is applicable from SQL Server 2016 through 2019.

Here's what I'll be talking about:

- How columnstore compression works and tips for picking the right data types

- Loading columnstore data quickly, especially on large servers

- Improving query performance on columnstore tables

- Maintaining your columnstore tables

This is an advanced level session. To get the most out of the material, attendees should have some practical experience with columnstore and query tuning, and a solid understanding of internals such as wait stats analysis. You don't need to bring a laptop to follow along.

Tags

  • United States Events
  • New York Events
  • Things to do in New York, NY
  • New York Science & Tech Events
Event ended

Joe Obbish – Clustered Columnstore For Performance


Follow this organizer to stay informed on future events

Events you might like

  • Performances by: Binki and Nnamdï

    Performances by: Binki and Nnamdï
    Performances by: Binki and Nnamdï

    Fri, Feb 17, 7:00 PM
    The Bowery Ballroom • New York, NY
    Free
  • Soberichs: Live Performance

    Soberichs: Live Performance
    Soberichs: Live Performance

    Sat, Mar 25, 8:00 PM
    Brooklyn Music Kitchen • Brooklyn, NY
    $12.71
  • Performances by: They Hate Change and PawPaw Rod

    Performances by: They Hate Change and PawPaw Rod
    Performances by: They Hate Change and PawPaw Rod

    Thu, Feb 16, 6:00 PM
    Dr. Martens Herald Square • New York City, NY
    Free
  • Single Release/Performance Opportunities

    Single Release/Performance Opportunities
    Single Release/Performance Opportunities

    Tomorrow at 11:00 PM
    Privileged Gentlemen's Club • Queens, NY
    $44.34
  • Central Park Street Performance

    Central Park Street Performance
    Central Park Street Performance

    Fri, Jul 11, 7:00 PM
    Central Park • New York, NY
    Free
  • 'DREAMING WOMAN' Public Performances

    'DREAMING WOMAN' Public Performances
    'DREAMING WOMAN' Public Performances

    Sun, Feb 12, 5:30 PM
    FiveMyles • Brooklyn, NY
    Free
  • "The You Voice" Special Performance

    "The You Voice" Special Performance
    "The You Voice" Special Performance

    Sat, Feb 11, 7:00 PM
    Mana Contemporary • Jersey City, NJ
    Free
  • Shrove Tuesday: Pancakes and Performance

    Shrove Tuesday: Pancakes and Performance
    Shrove Tuesday: Pancakes and Performance

    Tue, Feb 21, 7:00 PM
    New York Irish Center • Queens, NY
    $12.51

Site Navigation

Use Eventbrite

  • How it Works
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse New York Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite