Skip to content

SQL Server Indexing Strategies and Introduction to Columnstore Indexes

Photo of
Hosted By
Julie B.

Details

SQL Server Indexing Strategies:
Proper indexing reduces costs, improves performance, and mitigates blocking and deadlocks. This presentation will review SQL Server index architecture and examine a strategy to optimize indexes supporting OLTP, reporting, and mixed workloads.

Introduction to Columnstore Indexes:
Columnstore indexes are a different paradigm compared to traditional b-tree indexes, often providing orders of magnitude performance improvement for large scans common in reporting/analytical workloads. This presentation reviews columnstore index concepts and operational considerations.

Speaker:
Dan Guzman is a database professional with over 30 years of experience in administration, development, and solution architect roles. Dan is active in the SQL Server community, answering questions in online forums (Microsoft Q&A, stckoverflow.com, dba.stackexchange.com), and speaking at events on Microsoft data platform topics.

COVID-19 safety measures
Event will be indoors
The event host is instituting the above safety measures for this event. Meetup is not responsible for ensuring, and will not independently verify, that these precautions are followed.
St. Louis SQL Server and Business Intelligence User Group
St. Louis SQL Server and Business Intelligence User Group
See more events