Khám phá những siêu dữ liệu Khi SQL Server là ban đầu cài đặt, nó đã chứa các đối tượng một số hệ thống. Ngoài ra, mỗi cơ sở dữ liệu chứa các đối tượng người dùng mới một số hệ thống, bao gồm cả bảng biểu, quan điểm, các thủ tục lưu trữ, và chức năng | Part I Laying the Foundation SQL Data Services SDS The database side of Microsoft Azure is a full-featured relational SQL Server in the cloud that provides an incredible level of high availability and scalable performance without any capital expenses or software licenses at a very reasonable cost. I m a huge fan of SDS and I host my ISV software business on SDS. Version 1 does have a few limitations 10GB per database no heaps I can live with that no access to the file system or other SQL Servers distributed queries etc. and you re limited to SQL Server logins. I r p p Besides the general descriptions here Appendix A includes a chart detailing the differences 1 between the multiple editions. Exploring the Metadata When SQL Server is initially installed it already contains several system objects. In addition every new user database contains several system objects including tables views stored procedures and functions. Within Management Studio s Object Explorer the system databases appear under the Databases O System Databases node. System databases SQL Server uses five system databases to store system information track operations and provide a temporary work area. In addition the model database is a template for new user databases. These five system databases are as follows master Contains information about the server s databases. In addition objects in master are available to other databases. For example stored procedures in master may be called from a user database. msdb Maintains lists of activities such as backups and jobs and tracks which database backup goes with which user database model The template database from which new databases are created. Any object placed in the model database will be copied into any new database. tempdb Used for ad hoc tables by all users batches stored procedures including Microsoft stored procedures and the SQL Server engine itself. If SQL Server needs to create temporary heaps or lists during query execution it creates them in .
