Do you have all the right indexes on your SQL Server databases? Have you implemented any indexes other than traditional clustered and non-clustered indexes? If the answer to either question is “no” or “I don’t know,” then this session is for you. This Geek Sync will help introduce less commonly used index types and settings along with indexing methodologies. Follow along while we learn which indexes your SQL Server is begging you to make and others it wishes you would drop. Learn use cases for filtered, full-text, and columnstore indexes. There will be plenty of demos and shareable scripts to showcase the benefits too!
Speaker: Eric Blinn has been a SQL Server DBA in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading global provider of legal services with 47 offices in 20 countries. He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User's Group. He is incredibly proud and humbled to be a 2018-2019 IDERA Ace and has co-authored two IDERA Whitepapers. Look for Eric on twitter @SQL2TheSequel or his personal SQL Server blog, https://ericblinn.com/.
Topics: Database Performance, Database Diagnostics Products: SQL Diagnostic Manager for SQL Server