Search
Saturday, February 6, 2016 ..:: Home ::.. Register
  Login
 Sponsors Minimize

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

SQL Sentry

 


    
  Minimize

Moved to 2nd Tuesdays! - Wednesday, January 27, 2016

** Starting February 2016 - Change of Meeting Day **

Note: We typically meet on the second Tuesday of each month but adjust as needed to accommodate speakers. Our meetings begin at 5:30 PM and include time to network, discuss concerns relevant to the SQL Server community, and hear a presentation. We meet at the Microstaff IT facility in Columbia/Cayce, SC.

 

  
 Next Meeting Minimize

Next Meeting: Tue, Feb 09 2016

Improving Query Performance

RSVP: https://www.eventbrite.com/e/improving-query-performance-tickets-21065422245

Featured Presentation

Improving Query Performance

Speaker: Brian Kelley, Consultant Truth Solutions, LLC

Summary: We want queries to run fast. The faster queries run, the less likely they are to get in the way of other queries (blocking). The faster queries run, the less likely they are to collide where one will have to be rolled back (deadlocking). And the faster queries run, the more queries we can pump through the system, thereby improving performance. In this presentation we'll look at how the SQL Server query engine works: how it breaks down a query, how it uses indexes, and how it puts all this together to produce an execution plan. By understanding how the engine works, we'll understand how to improve our queries.

About Brian: Brian is a SQL Server author and columnist focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as an infrastructure and security architect where he works on Active Directory, Windows security, VMware, and Citrix in addition to Microsoft SQL Server. In the technical community, Brian is part of the Midlands PASS Chapter, an official chapter of PASS, where he currently serves as president and director of communications

When

iCal
UTC : Tue, Feb 09 2016 22:30 - 01:00
Event Time : Tue, Feb 09 2016 17:30 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Feb 09 2016 22:30 - 01:00

Where

440 Knox Abbott Drive
Cayce, South Carolina


    

Current Midlands PASS Chapter Officers

 

President: Brian Kelley 

Director of Communications: Eric Korth

Director of Membership: Bobby Heid

Treasurer: Nabil Pinto

 User Login Minimize

User Name:
Password:
Login   Register
Password Reminder

    
Copyright 2008-2009 by PASS Chapters Portal   Terms Of Use  Privacy Statement