Platinum Sponsor

Designing for simplification

Allowing the query optimiser do its job of simplification is an important feature if any database design. In this session, Rob takes us through ways that a database design can leverage features of the query optimiser such as redundant joins and end up with a system the provides a much simpler querying environment.
Presented by Rob Farley at SQLBits V
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 76 KB
    Video available WMV Video 208 MB
    Samples available Demos 4 KB
  • SpeakerBIO
    rob_farley.jpg
    Rob Farley runs LobsterPot Solutions, a Gold Partner SQL & BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia and SQLBits (UK), heads up the Adelaide SQL Server User Group, sits on the South Australian committee of the Australian Computer Society and has held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD and MCITP). He is an MCT and has been a SQL Server MVP since 2006. He has helped create several of the MCP exams, and wrote two chapters for the SQL Server MVP Deep Dives, and created the PASS chapter map that can be found on the PASS website.
    http://sqlblog.com/blogs/rob_farley http://feeds.feedburner.com/robfarley
  • Video
  • Session Files Explorer
    The network name cannot be found.