Posts From April, 2017

-August 2018+
SMTWTFS
2930311234
567891011
12131415161718
19202122232425
2627282930311
2345678
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (103)
  • Comments (0)

Archives

SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1 

Posted by altadmin Tuesday, April 18, 2017 12:11:00 PM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables. This session is all about when and how to apply in-memory tables in a production environment. After this session you will 1. Understand what in-memory tables are and how to create and maintain them including their limitations 2. Be able to identify performance gains over equivalent disk back tables 3. Comprehend the new data monitoring needed for in-memory table

In_MemoryPresentationLink is a dropbox link containing zip file containing my PowerPoint and all TSQL script demo files.

Bio:
Mike Byrd Bio:

Email: mbyrd@nctv.com Phone: 512-657-5349 Twitter: @ByrdNest_TX Web Site: www.TSQLMentoring.com Company: ByrdNest Consulting (Business Owner) Job Title: Senior Database Engineer Address: 213 Lakeview, Sunrise Beach, TX 78643-9308 LinkedIn profile: https://www.linkedin.com/in/mike-byrd-bbbaa01 Summary: Former rocket scientist and USAF Fighter Test Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Current in SQL Server 2016 (RC3), 2014, 2012, 2008R2, and 2005. Presented many SQL Saturday presentations at Austin, Baton Rouge, Denver, Dallas, Houston, Oklahoma City, South Florida, Gothenburg (Sweden), Atlanta BI, Albuquerque, Tampa, Jacksonville, Pensacola, Nashville, Atlanta, Oslo, and Sydney. Currently consulting for several Austin based software companies and free-lance writing a series of performance articles for SolarWinds (http://logicalread.solarwinds.com/?s=Byrd ). Also working up new data architecture and implementation plan for Daughters of Republic of Texas system. Specialties: SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced). Instruction: Have presented group TSQL classes for Newgistics, Austin, TX; Conexis, Irving, TX; and Mentor (Johnson & Johnson), Irving, TX, and individualized mentoring on a one-on-one basis, Have presented TSQ: Basic to Advanced PreCon at Dallas SQL Saturday #447 – 17 paid attendees with all excellent reviews. Recently presented Advanced TSQL 8 hour session to Solarwinds Corporate Office, Austin, TX with very positive reviews (25 attendees).
Site Map | Printable View | © 2008 - 2018 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund