Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organiser, or organise your very own event.

View upcoming events Create an event

Birmingham SQL Server User Group - Erin Stellato from SQLSkills on Statistics

SQL Midlands

Thursday, 12 March 2015 from 18:30 to 21:00 (GMT)

Birmingham SQL Server User Group - Erin Stellato from...

Ticket Information

Type Remaining End Quantity
SQL Midlands Attendee 11 Tickets Ended Free  

Share Birmingham SQL Server User Group - Erin Stellato from SQLSkills on Statistics

Event Details

Midlands SQL Server User Group - 12th March 2015, 6.30pm

Session 1: Erin Stellato (SQLSkills) - Updating Statistics Affects Query Performance More Than You Think

Session 2: Chris Adkin - An introduction to column store indexes and batch mode


 

Agenda

6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm Erin Stellato (SQLSkills) - Updating Statistics Affects Query Performance More Than You Think

Stop me if you've heard this one, "This query is slow, let's update statistics." But what does updating statistics *really* do to your query performance? And is it the right solution? While updating statistics may provide a short-term solution, it can bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you *do* update statistics, and you’ll see why that might not always be the right long-term solution.

Erin will be joining us from the US via web conference.

7:30pm - 8:00pm Break & Food

8:00pm – 9:00pm Chris Adkin - An introduction to column store indexes and batch mode

An introduction to column store indexes and batch mode, to include the new features that SQL Server 2014 brings to this area and a delve into why column store indexes and batch mode achieves the stunning performance gains in does when compared to row mode.

 

Getting There

We'll be at the Midlands Art Centre (MAC Birmingham), B12 9QH.

It's directly opposite Edgebaston Cricket Ground in Birmingham

Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground

Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.

The 45 & 47 are the best options, which depart from outside Boots in the Bullring, opposite where the main entrance to New Street station was, on Smallbrook Queensway.

http://www.networkwestmidlands.com/bus/bus-maps.aspx

Room: When you get there, we're in the 'Pincent Masons 1' room. On the 1st floor, above the main entrance.

 

Other Details

We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.

Dress code: relaxed

If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email Alex@SQLMidlands.com

 

Speaker profiles

ERIN STELLATO
SQLskills
Principal Consultant

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 13 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works.  Erin is an active member of the SQL Server community, is on the board of the Ohio North SQL Server User Group, and is a regular speaker at conferences like SQLintersection and the PASS Summit.  Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Email: Erin@SQLskills.com
Website: http://www.SQLskills.com
Full Bio: http://www.sqlskills.com/about/erin-stellato/
Blog: http://www.SQLskills.com/blogs/Erin


Chris Adkin

Chris is a SQL server consultant with fourteen years experience of using SQL Server, he has presented at both SQL Bits and for SQL Pass events in Europe, his passion is understanding SQL Server at a deep level and understanding how the engine behaves when it is pushed to its limits.


Do you have questions about Birmingham SQL Server User Group - Erin Stellato from SQLSkills on Statistics? Contact SQL Midlands

When & Where


MAC Birmingham (Midlands Arts Centre)
Cannon Hill Park
B12 9QH Birmingham
United Kingdom

Thursday, 12 March 2015 from 18:30 to 21:00 (GMT)


  Add to my calendar

Organiser

SQL Midlands

SQLMidlands - Bringing the West Midlands SQL Server community together

!!!! NOW MOVED TO MEETUP !!!!!

meetup.com/MicrosoftDataPlatformBirmingham

All future events will be promoted on Meetup, not here. Head over to the link above to sign up!

 


We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.

We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.

We're part of the UK SQL Server community at www.sqlserverfaq.com and we're an official PASS chapter (the Professional Association for SQL Server) covering the Midlands in the UK.

 

If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!

 

This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!

 

  Contact the Organiser

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.