Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 

Goals

1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup: http://eepurl.com/bf3IW1
2. Twitter: https://twitter.com/GlassUserGroup
3. LinkedIn: https://www.linkedin.com/groups?home=&gid=8264371&trk=anet_ug_hm
4. Meetup.com: http://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/

 


Next Meeting

Tuesday,

February

21

Black Arts Indexing

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 19:30 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

Abstract

You already know that good table design and proper indexing go hand-in-hand with writing high performance code so, to borrow a phrase from the auto industry, this presentation “Isn’t your daddy’s Buick”. We’re going to punch the accelerator and slam you back in your seat. We’ll first lay down a heavy-duty chassis and suspension of how indexes are structured and why understanding that structure is so very important. Then we’ll add the engine and transmission and learn why some indexes can hurt performance while others will make your code scream. After adding the body and detailing the interior, we’ll jump on the track and blow the doors off the classic myths of “seeks always being better than scans” and that “duplicate indexes are always bad”. We’ll also examine why too many indexes can hurt performance.

This presentation also has a trunk full of ancillary learning. Come join us for Ed Wagner’s powerful presentation on the mechanics of indexes and learn how to blow the competition away.

Bio

Ed is a Senior DBA with more than 20 years experience in database development and administration. He enjoys high-performance and "black arts" SQL. He's a member of SQL PASS In Detroit (SPID) and a frequent poster on SQLServerCentral.com. He's passionate about SQL Server and actually enjoys it. 

PASSChapterLogo.jpg

sql_micro_sm.gif



Back to Top
cage-aids
cage-aids
cage-aids
cage-aids