Beantown .NET Meeting on Thursday, 11/4/2010: Andy Novick, "Partitioning SQL Server"

by

Hi All –

Beantown .NET is going to be meeting Thursday, 11/4/2010.  This month we have Andy Novick presenting “Partitioning SQL Server Tables, Views and Indexed Views”. 

As always, our meeting is open to everyone so bring your friends and co-workers – better yet, bring your boss.  Please RSVP by email (beantown@benday.com) by 3pm on the day of the meeting to help speed your way through building security and to give us an idea how much pizza to order.

Future meetings:

– December 2 – TBA
– January 6 – Richard Hale Shaw, “On Time & Under Budget”
– February 3 – TBA

-Ben

When: Thursday, 11/4/2010, 6p – 8p
Where:
Microsoft NERD
1 Memorial Drive
Cambridge, MA

Directions: http://microsoftcambridge.com/About/Directions/tabid/89/Default.aspx

Parking: Paid parking is available in 1 Memorial Drive. 

Title: Partitioning SQL Server Tables, Views, and Indexed Views

Abstract:
Partitioning techniques in SQL Server help the developer and DBA manage large quantities of data and improve query performance in a variety of situations.  This presentation demonstrates the techniques used for Partitioned Tables, Partitioned Views, and Partition Aligned Indexed Views.

Reasons for partitioning in both OLTP and data warehouse applications will be disused along with these topics: Partitioning Basics, Hash Partitioning, Aligned vs. unaligned indexes, Index Views Basic, Index placement in Aligned and unaligned partitioning.

The topics include features from SQL Server 2000, 2005 and 2008. Come learn about these powerful schema design techniques.

Bio:

Andrew Novick is a developer/consultant and SQL Server MVP with 25 years in the computer industry and a focus on SQL Server and Microsoft .Net.  His practice includes designing databases, query optimization, analysis of performance problems, and building business applications.  His writings include the books Transact-SQL User-Defined Functions and “SQL Server 2000 XML Distilled.  You can find additional articles on his web site: http://www.NovickSoftware.com


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.