SQL Server Data Storage Formats: Internals, Performance and Best Practices
Kalen Delaney
This seminar will describe all the different formats available for storing data,
including the new filestream data, compressed data and sparse data columns in
SQL Server 2008. We'll look at the metadata to determine exactly what is being
stored and where, and discuss best practices for choosing the particular type of
storage format.
Goals
- Learn to use the tools for examining storage
- Compare the various storage formats available in SQL Server 2005
- Understand the functionality of the new SQL Server 2008 storage options
- Explore the costs and benefits of each type of format
Prerequisites
A thorough understanding of basic storage concepts, including files, extents and
pages. Basic understanding of special formats in SQL 2005 including LOB and
row-overflow. Basic familiarity with TSQL, including 3-table join operations and
grouping.
Why should I attend?
Ever wondered about the internal storage structures of SQL Server? As a DBA you should be thinking about this to better understand how SQL Server is doing what it is doing. What Kalen doesn't know about the internals of the storage engine for SQL Server is not worth knowing so if you want to know what is going on from someone who knows then come to this seminar.
Course Length & Type
One day instructor led seminar.
Location
3rd November 2008 Rothamsted Manor, Harpenden
Conveniently located only 4 miles from the M1 and close to Harpenden railway
station with good links to London. Rothamsted Manor is part of the larger
Rothamsted Research facility, but retains a secluded and tranquil feel ideal for
learning.
Events are held in The Great Drawing Room at the manor house itself. For full
directions see Rothamsted Manor's
How to Find Us guide.
The Great Drawing Room Rothamsted Manor & Conference Centre
Rothamsted Research
Harpenden
AL5 2JQ
Rothamsted Manor
web site.
Timetable
Registration
Register before 20th October 2008 and receive your early bird discount:
- £200 + VAT before 20th Oct
- £249 + VAT full rate
Discounts
Early bird discounts must be booked before 20 October 2008,
and full payment must be received by 27 October 2008 to qualify for the discount.
We offer a discount of 5% for 2 - 4 places and a 10% discount for 5 or more places booked.
Discount bands apply to the total number of places booked, they are not restricted to an individual attended or course, i.e. booking two people on one course or one person on two courses will both qualify the 5% discount for 2 places booked.
For full details please see our Event Terms & Conditions