SQL Server 2008; Partitioning
This session will discusses the fundamentals of table-based partitioning in SQL Server 2008. A challenge facing all developers is to design systems that are maintainable, scalable, and perform well. Table-based partitioning is one approach to help to achieve a reasonable balance between maintainability and scalability vs. performance. The start of the session will cover an overview of Table-Based Partitioning, then move to Creating Partitioned Tables then Querying Partitions and end with Managing Partitions.
Frank Tillinghast is a senior consultant with MTOW Software Solutions. He is a Microsoft Certified Solution Developer and has been developing applications for over 15 years. Most of his time is spent consulting for companies nationwide with troubled projects or mentoring projects to successful completion. When he is not developing software or mentoring clients, Frank is teaching other developers. He has taught thousands of application developers how to create business solutions with Visual Studio .NET. VB.NET, ASP.NET, Visual C#, and SQL Server.