Thursday, September 02, 2010   Login

Pacific Northwest SQL Server Users Group (PNWSQL.org)

You are here: Home  
Next Meeting

August 11 2010 (Wednesday), 7:00 pm
35/Kalaloch, Microsoft campus, Redmond

Indexing Guidelines

Greg Larsen, DBA at Washington State Department of Health, SQL Server MVP and PASS Regional Mentor.

This session will discuss indexing guidelines. During this discussion there will be information how developers and DBA’s should approach the indexing development lifecycle. This lifecycle will help attendees understand that you shouldn’t just develop some indexes while you are developing your applications and then forget about them.  In addition some indexing guidelines will be discussed.  These guidelines will help you make better choices on which columns to select for your indexes and how those columns should be ordered in multi-column indexes.  There will be  number of demonstrations to support this discussion. Lastly an indexing toolkit (a set of scripts) that you can use to help manage your indexes will be provided.

Greg Larsen is a DBA at Washington State Department of Health (DOH). Greg has been working with SQL Server since 1999. He has authored over 100 articles related to SQL Server. He holds a MCITP Database Administrator and Developer certification for SQL Server 2005 and is a SQL Server MVP. Greg also hosts the www.sqlserverexamples.com website which contains a number of T-SQL examples to help you manage your SQL Server environment and application T-SQL code.

    
Welcome

Welcome to the Pacific Northwest SQL Server User Group (PNWSQL) web site!

We meet every second Wednesday of the month on the Microsoft Redmond Campus, usually in Building 35/Kalaloch (just behind reception.) Check the signs when you arrive to confirm.

The PNWSQL group is one of the original SQL Server User Groups, meeting monthly on the Microsoft Redmond campus since the early 1990's.

Directions: From I-5 or I-405, go east on SR-520 toward Redmond, take the 40th Street exit, turn right at the end of the ramp, continue straight through the first traffic light at 156th AVE NE, take the next right, and then first left.  Park in the lot on your right, when facing east, the meeting is the building to your left. Please consult this campus map for more information. (Contact the PNWSQL President.)

7:00 - 7:30 - Announcements and Technical Q&A
7:30 - 9:00 - Presentation


IMPORTANT: You must bring a current printout of this webpage or your email invitation to be admitted into the building. Register your name, vehicle make, model, license#, and picture ID at the registration desk. Your printout may also be used in a prize drawing.

Name: _________________________________________

Vehicle Make/Model: _________________________________________

Vehicle License #: _________________________________________
 
 

    
Announcements

Bellevue, August 9-13, SQL Skills 5-Day SQL Immersion Event

Upcoming Meetings:

Aug 11, 2010: Greg Larsen, DBA, WA DOH, Indexing Guidelines

Sep 8, 2010: Robert Davis, Microsoft DBA (PQO and CAP), Disaster Recovery

Oct 13, 2010: Cihan Biyikoglu, SQL Server Team, SQL Azure

 

    
Useful Links
    
Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

    
Home  |  Meeting Archive  |  Photo Gallery  |  Discussions  |  About Us  |  Resources
Copyright 2008 by PASS Chapters Portal   |  Privacy Statement  |  Terms Of Use