Название: SQL Server Metadata Succinctly Автор: Joseph D. Booth Издательство: Syncfusion, Inc. Год: 2019 Язык: английский Формат: pdf (true), rtf, epub Размер: 10.1 MB
SQL Server is a very complex and powerful product, but it provides tremendous amounts of data about itself. You can use this metadata to improve your database design, increase performance, review security, and more. Joseph D. Booth will show readers sample scripts and queries using information schema views as well as SQL Server-specific views in SQL Server Metadata Succinctly.
Microsoft SQL Server (and other SQL systems) also provide a large amount of data about their servers, users, tables, and stored procedures. In this book, we are going to explore that metadata and provide example scripts and queries to learn a lot of information about your SQL environment.
In this book, we will start with the information schema views and provide some handy queries about the server's data tables. We will then explore some of the views that are unique to Microsoft and provide very useful information about SQL Server.
Table of contents:
Introduction Information Schema Server Information Database Properties Tables and Columns Performance Security
Скачать SQL Server Metadata Succinctly
|