tailieunhanh - Microsoft SQL Server 2000 Weekend Crash Course phần 10

Làm thế nào để bạn tạo ra các số liệu thống kê cho một bảng? Ai sử dụng số liệu thống kê? 25. Những gì bạn sẽ sử dụng như là dữ liệu đầu vào cho Tuning Wizard Index? 26. Làm thế nào bạn có thể tối ưu hóa hiệu suất giao | Session 30 Advanced Features of SQL Server 2000 347 Online Analytical Processing OLAP Services and the Multidimensional Expressions MDX they use are by far the most complex and advanced SQL Server components. Companies are using OLAP more and more as they try to make sense of their tons of accumulated data. OLAP is used in the mysterious field called data analysis and many books are dedicated to this use. This session will only briefly mention these services and their potential uses. The standard database table represents a flat matrix SQL Server 2000 Analysis Services use the notion of cubes. The data and corresponding objects are multidimensional having more dimensions than our four-dimensional space-time continuum the number of dimensions is limited only by your imagination and hardware capabilities. You must install SQL Server Analytical Services. You do this in much the same way that you install English Query. Make sure you go through Books Online for the Analytical Services and work through the samples it includes because using them isn t simple. Running the Web Assistant Wizard I briefly introduced the Web Assistant Wizard in Session 4. This wizard provides you with an easy way to publish your information on the Internet. Follow these steps to use it 1. Launch the Web Assistant Wizard from the Enterprise Management Console Tools o Wizards o Management o Web Assistant Wizard . Click Next on the Welcome screen. The next screen Select Database will prompt you to select the database you wish to publish. Select Pubs and click Next. 2. On the next screen Start a New Web Assistant Job specify a job name and the data you want to be published. The choices are as follows Data from the tables and columns you specify Result set of a stored procedure you specify Data from a T-SQL query you specify Name your Web assistant job and select Data from the Tables and Columns you specify. Click Next. Part VI Sunday Afternoon Session 30 348 Sunday Afternoon 3. On this screen .