| January Meeting InvitationPlease join us for the monthly Charlotte SQL Server User Group evening meeting.What ~ Charlotte SQL Server User Group MeetingWhen ~ Wednesday, January 30th, 20195:30 PM Networking with Food & Refreshments6:00 PM Technical Presentation7:30 PM Meeting EndWhere @ 8055 Microsoft Way, Charlotte, NC 28273 Map itPresenter – Sandra Peele – CMI Solutions Topic – Index Trek Registration – Free RSVP required at EventBriteRegister for the Meeting |
| Sandra Peele Sandra Peele started her career in the 1980’s as a demand forecaster in the materials planning department of AT&T Network Systems. She left the workforce in 1990 to raise a family and in 2010, returned to school to study database technology, eventually teaching courses herself. She has both MSCE: Data Management and Analytics and Oracle 11g OCA certifications. Sandra is a SQL Developer at CMI Solutions, a Microsoft Partner specializing in software for convenience storesWhen learning something new, it’s helpful to have a foundation. Yet, indexes are often taught with only one or two sentences of explanation before CREATE INDEX. I recall a student, exasperated by the textbook definition saying, “Will someone just SHOW ME an index!” The goal of this high level presentation is to do just that. In this 60 minute mission, we’ll explore nonclustered and clustered indexes as well as the strange new world of columnstore indexes. Rather than focus on space and time requirements of indexes and index maintenance, we’ll seek out new understanding:Why well-designed indexes speed up queries.Why queries must be engineered carefully to use indexes.Why indexes have both benefits and drawbacks.After the mission, you’ll be prepared to further explore the galaxy of indexes. This presentation was co-produced with Stéphane Faroult, author of Getting the Message Across: Using Slideware Effectively for Technical Presentations and The Art of SQL. |
