Indexes and indexing are huge topics and given half a chance, Kimberly
and Paul could talk for days on this stuff! In this session, they've
chosen their favorite indexing topics to discuss. The internals section
will cover the structures and benefits of various kinds of indexes and
show the 2005 feature "INCLUDE" and the 2008 feature "filtered
indexes". Fragmentation is often mis-understood and so this section
will explain the various forms of fragmentation, how they can occur
when a schema or workload is poorly designed, then how to detect and
remove fragmentation in a way that causes least disruption to the
production workload.
Details
Thursday, 04 Sep 2008, 18:00 to
21:00
Cost: Free
Contact:
ndflanagan@o2.ie
Location
The Auditorium in Microsoft Atrium
Block B, Carmanhall Road, Sandyford Industrial Estate
Dublin