Indexes
Defragging Indexes for Beginners
Indexes over time become fragmented and as a result don’t work quite as well as they should. This short talk will show you how an index can become fragmented and will also show you the steps to fix index fragmentations.
Effective Indexes for Beginners
From SQL Server 2005 onwards, we have been able to use a DMV to identify which of our indexes are effective and which of our indexes can be disabled. This short talk will show you how and why you should be checking the effectiveness of your indexes.
Presented by Amanda Jackson
Consultant/Developer with Fronde Systems Ltd with almost 20 years experience in the IT industry. Amanda is currently focusing on SQL development and BI and is working towards Microsoft BI development and maintenance certification. In the past she has covered most roles in IT including: Developer, Network Admin, Change Control Manager, Source Control & Build Manager, QA, Games Development, Novell DBA.
Amanda is also the founder of Girl Geek Dinners in New Zealand.
Location:
Fronde House
Level 7,
131 Queen Street
Auckland
Event start: 19/08/2009 6:00:00 p.m.