Designing for Simplification

DESCRIPTION

Join Rob Farley, an experienced SQL Server professional and Microsoft MVP, as he explores essential principles of simplification and modularization in SQL Server design. This session covers key topics including the use of stored procedures, views, and functions, and when to avoid unnecessary joins. Discover the differences between scalar and table-valued functions and learn to distinguish between effective and ineffective strategies. Enhance your SQL skills by focusing on simplifying your code and improving your database design.

Download

1 / 2

Mar 18, 2014

Télécharger la présentation

Designing for Simplification

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

Rob Farley Owner / Principal – LobsterPot Solutions Leader – Adelaide SQL Server User Group Microsoft MVP (SQL Server) Designing for Simplification
Modularisation(the only real slide) • Stored Procedures • Views • When joins become redundant • Functions • Scalar v Table-valued • Good v crap • Simplifiable v Procedural