Basic Tenets of Designing for Performance
Designing for performance requires making trade-offs. For example, to get the best write performance out of a database, you must sacrifice read performance. Before you tackle database design issues for an application, it is critical to understand your goals. Do you want faster read performance? Faster write performance? A more understandable design?
Following are some basic truths about physical database design for SQL Server 2014 and the performance implications of each:
It’s important to keep table row sizes as small as possible. Doing so is not about saving disk space. Having smaller rows means more ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
