add-memberalign-toparrow-leftarrow-rightbellblockcalendarcamerachatchevron-leftchevron-rightchevron-small-downchevron-upcircle-with-crosscomposecrossfacebookflagfolderglobegoogleimagesinstagramkeylocation-pinmedalmoremuplabelShape 3 + Rectangle 1pagepersonpluspollsImported LayersImported LayersImported LayersshieldstartwitterwinbackClosewinbackCompletewinbackDiscountyahoo

SQL Server Optimization

  • Mar 12, 2013 · 6:00 PM
  • This location is shown only to members

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.

Join or login to comment.

  • Ned W. R.

    Best meeting ever. Filled with tech tips and great demos

    March 13, 2013

  • A former member
    A former member

    It was awesome, and I NEVER, EVER use that word (oops - I just did.) I learned so many things that I can used in my SQL applications. Itching to try them out!

    March 12, 2013

  • Andrea S.

    Sorry I will not be attending tonight!

    March 12, 2013

  • Mark A.

    Assuming I can figure out the parking situation and locate the room I'll be there.

    March 5, 2013

    • Ned W. R.

      Find Lot M on the interactive map. It is in the back by the wild life area. Free parking. Then find the Computer Information building which is a short walk away past the student union. We will be in the big glass room on the first floor. Look for people eating pizza.

      March 6, 2013

    • Ned W. R.

      Wild life is the campus, I meant the wild flower

      March 6, 2013

10 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy