Microsoft SQL Server 2008 R2 Unleashed- P239

Microsoft SQL Server 2008 R2 Unleashed- P239:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2344 CHAPTER 56 SQL Server Disaster Recovery Planning exec sp_linkedservers Returns the list of linked servers defined in the local server. exec sp_helplinkedsrvlogin Provides information about login mappings defined against a specific linked server used for distributed queries and remote stored procedures. exec sp_server_info Returns a list of attribute names and matching values for Microsoft SQL Server. exec sp_helpdb dbnamexyz Provides information about a specified database or all databases. This includes the database allocation names sizes and locations. use dbnamexyz go exec sp_spaceused exec sp_spaceused Set of SQL statements that provide the actual database usage information of both data and indexes for the specified database name dbnamexyz . use dbnamexyz go exec sp_spaceused go exec sp_configure - Get the current SQL Server configuration values by running sp_configure with the show advanced option USE master EXEC sp_configure show advanced option1 1 RECONFIGURE go EXEC sp_configure Go name minimum maximum config_value run value access check cache bucket count 0 65536 0 0 access check cache quota 0 2147483647 0 0 Ad Hoc Distributed Queries 0 1 0 0 affinity I O mask -2147483648 2147483647 0 0 affinity mask -2147483648 2147483647 0 0 affinity64 I O mask -2147483648 2147483647 0 0 affinity64 mask -2147483648 2147483647 0 0 Agent XPs 0 1 1 1 The Overall Disaster Recovery Process 2345 allow updates 0 1 0 0 awe enabled 0 1 0 0 backup compression default 0 1 0 0 blocked process threshold s 0 86400 0 0 c2 audit mode 0 1 0 0 clr enabled 0 1 0 0 common criteria compliance enabled 0 1 0 0 cost threshold for parallelism 0 32767 5 5 cross db ownership chaining 0 1 0 0 cursor threshold -1 2147483647 -1 -1 Database Mail XPs 0 1 0 0 default full-text language 0 2147483647 1033 1033 default language 0 9999 0 0 default trace enabled 0 1 1 1 disallow results from triggers 0 1 0 0 EKM provider enabled 0 1 0 0 filestream access level 0 2 2 2 fill factor 0 100 0 0 ft crawl .

Không thể tạo bản xem trước, hãy bấm tải xuống
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.