SQL Server Optimization

NOTE: This is a Tuesday night

Meeting Agenda:
6:00-6:30 - Welcome/Pizza - Sponsored by TEKSystems
6:30-6:45 - Organizational Announcements
6:45-8:30 – Program
8:30-8:45 - Give-aways (if I have any)

Program Agenda Overview of the SQL Server product: storage engine, SQL OS, query optimizer, etc. Physical storage: data and index page layout, caching mechanisms, etc. Clustered and Non-clustered indexes Statistics and Selectivity: why SQL Server probably knows best Performance enhancing design: choice of cluster keys, data types, normalization, data access methods Finding out what’s slow: data management views and DBCC commands Fixing what’s slow (A): query plan analysis Fixing what’s slow (B): index strategies Fixing what’s slow (C): what else might it be that’s not as obvious? CPU? Memory pressure? Stale plans? Inappropriate fragmentation? Bad Statistics? Lots of real demos – scripts and reference DB provided Lots of opportunities for questions Douglas Kline, Ph.D., is an Information Systems professor at UNC Wilmington, and is currently the director of the MS in Computer Science and Information Systems graduate program. Before returning to higher education, he worked for Computer Horizons Corporation as a Software Developer, System Architect, and Project Manager, managing a team of 15 on a large custom middleware project. As an IS Professor at Sam Houston State University, he helped create the Management Information Systems major in the College of Business Administration. He has been at UNC Wilmington since 2001, teaching a variety of undergraduate and graduate courses. He has published in the areas of IT Strategy, IS Curriculum, Artificial Neural Networks, and User Perceptions of Security. He has been teaching MS SQL Server for over 10 years in graduate and undergraduate classes. He focuses on SQL Internals and Data Structures, Query Analysis, Indexing Strategies, and Designing for Performance.