Microsoft® SQL Server® 2012 Bible
87 Chapter 5: SQL Server Management and Development Tools 5 benefi t of registering a server is that it can be given an alias, o ...
88 Part I: Laying the Foundations Server Groups Within the Registered Servers tree, servers may be organized by server groups. T ...
89 Chapter 5: SQL Server Management and Development Tools 5 FIGURE 5-4 Multi-server results in Management Studio. Management Stu ...
90 Part I: Laying the Foundations Navigating the Tree In keeping with the Explorer metaphor, Object Explorer (see Figure 5-5) is ...
91 Chapter 5: SQL Server Management and Development Tools 5 ■ (^) Tables: Used to create and modify the design of tables, view a ...
92 Part I: Laying the Foundations ■ (^) Availability Groups: Lists the Availability Groups confi gured on this server. This node ...
93 Chapter 5: SQL Server Management and Development Tools 5 Filtering Object Explorer Some databases are huge. To ease navigatin ...
94 Part I: Laying the Foundations The Table Designer Creating a new table, or modifying the design of an existing table, is easy ...
95 Chapter 5: SQL Server Management and Development Tools 5 Chapter 7, “Relational Database Design and Creating the Physical Dat ...
96 Part I: Laying the Foundations ■ (^) Previous versions of the Database Diagram tool were not schema aware, however, the SQL S ...
97 Chapter 5: SQL Server Management and Development Tools 5 ■ (^) Grid pane: Lists the columns displayed, fi ltered, or sorted. ...
98 Part I: Laying the Foundations However, the Query Designer is no substitute for the Query Editor. Unlike Query Editor, it can ...
99 Chapter 5: SQL Server Management and Development Tools 5 You can install custom reports in any Object Explorer node by placin ...
100 Part I: Laying the Foundations You can set Query Editor’s connection bar’s (at the bottom of the Query Editor) display color ...
101 Chapter 5: SQL Server Management and Development Tools 5 ■ (^) You can drag and drop column names from the Object Explorer t ...
102 Part I: Laying the Foundations Shortcuts and Bookmarks Bookmarks are a great way to navigate large scripts. You can set book ...
103 Chapter 5: SQL Server Management and Development Tools 5 Query ➪ Execute Query, click the Run Query toolbar button, use the ...
104 Part I: Laying the Foundations Alternatively, the results can display in another tab, instead of at the bottom of the query ...
105 Chapter 5: SQL Server Management and Development Tools 5 What makes the query execution plans even more important is that SQ ...
106 Part I: Laying the Foundations Getting a Jumpstart on Code with Templates and Code Snippets ............................ Man ...
«
2
3
4
5
6
7
8
9
10
11
»
Free download pdf