How should you structure your tables? You'll learn as we cover how heaps cause performance problems, see what's really inside an index, explain the logic behind IDENTITY and GUID fields as clustering keys, and show when to break the best practices.
Speaker: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and sp_AskBrent®, coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com. He's a Microsoft Certified Master of SQL Server and a Microsoft MVP.
Topics: Database Performance, Database Diagnostics Products: SQL Server Tools for Better Performance