Название: 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
Microsoft SQL Server 2008 For Dummies Название: Microsoft SQL Server 2008 For Dummies Автор: Mike Chapple Издательство: For Dummies Год: 2008 Формат: PDF Страниц: 408 Для сайта:...
SQL Server on Linux (+code) Название: SQL Server on Linux (+code) Автор: Jasmin Azemovi? Издательство: Packt Publishing Год: 2017 Страниц: 222 Формат: True PDF, EPUB, AZW3...