Welcome to Chi-SSUG!

Please click here for general group information.  Also follow us on twitter at @ChiSQL or our hashtag #ChiSQL.  We look forward to seeing you at our next meeting!

 


Topic:

 

Indexing - Art vs. Science

Date:

 

Thursday, February 11th, 2016 @ 5:30 PM
(You must RSVP by 9:00 AM, the Wednesday prior to the meeting to attend)

Location:

 

Microsoft Technology Center, 200 East Randolph Drive, Suite 200 Chicago, IL 60601

Speaker:

 

Wendy Pastrick

Abstract:

 

Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.

Bio:

 


            Wendy Pastrick, who joined the PASS Board in 2013, is from Chicago, IL, and for the past 13 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include working with the Women in Technology Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor for the Midwest region, and serving on the 2011 Election Review Committee and the 2012 PASS Summit Program Committee.                      

 

 

 



Availability Groups versus Clustered Instances of SQL Server

Availability Groups versus Clustered Instances of SQL Server


Performance Tuning When You Can't Fix the Queries