EDMPASS - Professional Association for SQL Server Edmonton Chapter, Edmonton SQL Server User Group

 

Welcome

EDMPASS is a not-for-profit association that organizes events to promote knowledge sharing, to exchange ideas, and to unite Edmonton's SQL server professionals.
 

Announcements

PASS Summit 2013 is fast approaching and EDMPASS has a discount code SUM171CH to save $150 off the registration fee.

Chapter: SQL PASS Edmonton
Unique discount code: SUM171CH

 

Next Meeting: Wed, May 22 2013

EDMPASS May 2013 meeting with Harry Zheng

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://edmpass201305.eventbrite.ca

Topic:Index the obvious and not so obvious
Description:
First I will talk about the SQL Server index basics, including the B-Tree structure, clustered and non-clustered index, Primary key and unique index, as well as covering index. Then we will discuss some basic index design steps and see how index can help query performance. Finally we will review some common index issues.

When

iCal
UTC : Wed, May 22 2013 23:00 - 02:00
Event Time : Wed, May 22 2013 17:00 - 20:00 (GMT-07:00) Mountain Time (US & Canada)
Your Local Time: Wed, May 22 2013 23:00 - 02:00

Where

7 Sir Winston Churchill Square

Edmonton, Alberta
Direction: Centennial Room (basement level)

Featured Presentation

Index the obvious and not so obvious

Speaker: Harry Zheng, Data Architect NetDB Solutions Inc

Summary: First I will talk about the SQL Server index basics, including the B-Tree structure, clustered and nonclustered index, Primay key and unique index, as well as convring index. Then we will discuss some basic index design steps and see how index can help query performance. Finally we will review some common index issues.

About Harry: None

Attachments

[Attachments]