tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 15

Quản lý Studio gửi T-SQL lệnh SQL Server, hoặc sử dụng SQL Đối tượng quản lý (SMOs), giống như bất kỳ ứng dụng client khác. Nó cũng kiểm tra SQL Server và trình bày các dữ liệu và cấu hình cho xem. Thật thú vị khi xem các lệnh đã gửi bởi Management Studio để SQL Server. | Part I Laying the Foundation on a workstation and connects to the actual server. Management Studio sends T-SQL commands to SQL Server or uses SQL Management Objects SMOs just like any other client application. It also inspects SQL Server and presents the data and configuration for viewing. It s interesting to watch the commands sent by Management Studio to SQL Server. While Management Studio can generate a script for nearly every action the actual traffic between SQL Server and its clients may be viewed using SQL Profiler which is discussed in Chapter 56 Tracing and Profiling. What s New in Management Studio SQL Server 2008 s Management Studio is an evolution of SQL Server 2005 s Management Studio which was a merger of the old Enterprise Manager and Query Analyzer. Besides a few new nodes in Object Explorer and small tweaks to the UI Management Studio has two new very cool powerful features worth mentioning Using Registered Servers and Server Groups the Query Editor can now send T-SQL statements to multiple servers with a single execute. The Query Editor now includes a very nice IntelliSense that completes table and column names and a code outlining feature that collapses multi-line statements and procedures. For SQL Server 2008 Buck Woody SSMS 2008 Product Manager and his team went all out with enhancements tweaks and new features. The new supercharged Management Studio is one of my personal favorite new features of SQL Server 2008 with at least 28 count em features Using Registered Servers and Server Groups the Query Editor can now send T-SQL statements to multiple servers with a single execute. Registered servers can now point to a configuration server a central server that holds the configuration settings for several instances of SSMS so DBAs can share server configurations. Partitioning is easier to configure using a new wizard. Performance Studio presents drill-through reports of information gathered by the Performance Data Warehouse. The Activity Monitor can