Summary
Establishing a database maintenance plan is important. Just like your car or your home, a database needs maintenance to keep working properly. The powerful features available with the SQL Server 2014 maintenance plans and Maintenance Plan Wizard make the creation of a robust maintenance plan relatively easy. If you establish your maintenance plans early in the life of your databases, you will save yourself time and aggravation in the long run.
Chapter 31, “Understanding SQL Server Data Structures,” delves further into the importance of SQL Server Data Structures. The physical files associated with databases, how tables and indexes are placed in filegroups, and how rows in tables are stored in a database are just some of the topics covered ...
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.
