APPENDIX F SQL Database Design Object Summary
This appendix has an abbreviated listing of many database objects. It includes
• Stored procedures
• CLR integrated objects
• Indexes and indexed views
The mind is not a vessel to be filled, but a fire to be ignited.
In early chapters of this book, we covered some basic database design objects such as constraints and views. Later we introduced some advanced database objects such as user-defined functions, stored procedures, and triggers. When we talked about optimizing databases, we brought indexes into the mix.
All of the objects work together to produce a cohesive database solution. One of your goals as a DBA is to understand what the available ...