Partitioning in the Real World

If you haven't discovered yet what partitioning can do for you in SQL Server 2005 - then this session is for you. Many resources teach the basics of partitioning - BUT this session gives a view of partitioning from the trenches - ie. how it's been used in the real world to solve very difficult problems. This session is comprehensible even for those that have not used partitioning yet - as it starts with a 5-minute overview. Partitioning is a simple concept to grasp and this session goes beyond the concepts and shows in-depth how partitioning has been implemented in the real world. The session uses real case studies of very different and difficult to solve problems and it is shown how partitioning solve these problems in an elegant and simple way and more importantly how to keep a partitioned system performing optimally. By drawing on real case studies with which the presenter has direct experience the session shows many lessons learned from implementing partitioning that go beyond the basic concepts and show how real world problems were really solved by using partitioning.
Presented by Hue Holleran at SQLBits I
  • Downloads
    Samples available Sample Code 35 KB
  • SpeakerBIO
    Hue Holleran is a professional consultant specialising in Enterprise RDBMS solutions: SQL Server since v4.2, Oracle since v7 and Hadoop since its first releases - and all versions of those products since. After more than 20-years as a consultant to over 100-organisations - and the largest global brands in various industries - Hue has established a reputation for developing innovative BUT practical solutions. Since developing in mainframe 'C' and DBase/FoxBase+ in the 1980's and Oracle and SQL Server in the 1990's, Hue's current interest is in multi-terabyte and multi-threaded BigData and Enterprise-scale solutions. Hue has frequently presented on various topics since presenting for Microsoft at all UK venues for the Visual Studio 6 launch in 1998, Hue's current focus is on leveraging the database's enterprise capabilities to implement truly robust and resilient systems that retain excellent performance even in the most challenging of environments.
  • Video
    The video is not available to view online.