I came across this great source showing the slides for Google’s Seminars for Success. Specifically the Analytics 301: Advanced Tracking & Technical Implementations set has some great slides providing clarity on data table limits (around p.40) and how to work around the limitations with profiles.
(A lot cheaper then trekking to the nearest american city!)