微软SQL Server 2008 CTP版的特性
自今年六月发布了 SQL Server 2008 的Community Technology Preview(CTP)1后，只隔了六个星期， 微软 又发布了CTP2，在最新的CTP版本中，有以下一些 特性 ： ? 报表服务方面的新 特性 ，包括一个新的报表设计器、配置工具和不再依赖于Microsoft IIS的企业报
自今年六月发布了SQL Server 2008的Community Technology Preview(CTP)1后，只隔了六个星期，微软又发布了CTP2，在最新的CTP版本中，有以下一些特性：
? 报表服务方面的新特性，包括一个新的报表设计器、配置工具和不再依赖于Microsoft IIS的企业报表引擎(enterprise reporting engine)。微软称，该报表引擎比早些时候发布的版本扩展性更高，现在还支持一个被称为Tablix(table和matrix的合并)的混合型报表项。
? 新的数据挖掘(分析服务)时间序列预测算法，能够实现更稳定的长期预测。
? 采用新的目录视图和一些动态管理函数能够有效地发现对象间的依存关系。这对DBA和第三方工具来说非常有用。
? 一个新的架构――Performance Data Collection，能够从SQL服务器和操作系统手机各种不同类型的有用数据，更加有利于日常维护和灾难排除。
? 为服务器系统准备了一个新的全面事件处理系统，称之为SQL Server Extended Event，该系统能够帮助把SQL服务器、操作系统甚至应用软件中发生的事件联结在一起。
? 数据库镜像升级到2.0版本，增强了多项性能，使整个平台更加可靠。
? 改进了ORDPATH以处理分层数据，能够有效地执行分层数据的查询、存储和管理操作。
? 支持大型用户自定义类型数据，用户可以扩大自定义类型数据容量，不再受8KB的限制。
? 新的日期和时间数据类型，允许日期和时间信息的分离，支持更广的范围、更高的精确度以及时区偏移值监测的datetime数据类型。这些新的数据类型对于管理数据仓库和联机事务处理(OLTP)来说非常有用。
? 改进了XML支持体系：可支持新的日期和时间数据类型，并加强了对周边的联合数据类型的支持。
不管是哪个版本的CTP，新特性都数不胜数。
|
精彩推荐
|
|
SQL Server 2008 功能、特性介绍 |
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1666
14
1426
52
1328
25
1273
29
1255
24
What is the difference between HQL and SQL in Hibernate framework?
Apr 17, 2024 pm 02:57 PM
HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).
Microsoft releases Win11 August cumulative update: improving security, optimizing lock screen, etc.
Aug 14, 2024 am 10:39 AM
According to news from this site on August 14, during today’s August Patch Tuesday event day, Microsoft released cumulative updates for Windows 11 systems, including the KB5041585 update for 22H2 and 23H2, and the KB5041592 update for 21H2. After the above-mentioned equipment is installed with the August cumulative update, the version number changes attached to this site are as follows: After the installation of the 21H2 equipment, the version number increased to Build22000.314722H2. After the installation of the equipment, the version number increased to Build22621.403723H2. After the installation of the equipment, the version number increased to Build22631.4037. The main contents of the KB5041585 update for Windows 1121H2 are as follows: Improvement: Improved
Microsoft Edge upgrade: Automatic password saving function banned? ! Users were shocked!
Apr 19, 2024 am 08:13 AM
News on April 18th: Recently, some users of the Microsoft Edge browser using the Canary channel reported that after upgrading to the latest version, they found that the option to automatically save passwords was disabled. After investigation, it was found that this was a minor adjustment after the browser upgrade, rather than a cancellation of functionality. Before using the Edge browser to access a website, users reported that the browser would pop up a window asking if they wanted to save the login password for the website. After choosing to save, Edge will automatically fill in the saved account number and password the next time you log in, providing users with great convenience. But the latest update resembles a tweak, changing the default settings. Users need to choose to save the password and then manually turn on automatic filling of the saved account and password in the settings.
Microsoft Win11's function of compressing 7z and TAR files has been downgraded from 24H2 to 23H2/22H2 versions
Apr 28, 2024 am 09:19 AM
According to news from this site on April 27, Microsoft released the Windows 11 Build 26100 preview version update to the Canary and Dev channels earlier this month, which is expected to become a candidate RTM version of the Windows 1124H2 update. The main changes in the new version are the file explorer, Copilot integration, editing PNG file metadata, creating TAR and 7z compressed files, etc. @PhantomOfEarth discovered that Microsoft has devolved some functions of the 24H2 version (Germanium) to the 23H2/22H2 (Nickel) version, such as creating TAR and 7z compressed files. As shown in the diagram, Windows 11 will support native creation of TAR
Microsoft's full-screen pop-up urges Windows 10 users to hurry up and upgrade to Windows 11
Jun 06, 2024 am 11:35 AM
According to news on June 3, Microsoft is actively sending full-screen notifications to all Windows 10 users to encourage them to upgrade to the Windows 11 operating system. This move involves devices whose hardware configurations do not support the new system. Since 2015, Windows 10 has occupied nearly 70% of the market share, firmly establishing its dominance as the Windows operating system. However, the market share far exceeds the 82% market share, and the market share far exceeds that of Windows 11, which will be released in 2021. Although Windows 11 has been launched for nearly three years, its market penetration is still slow. Microsoft has announced that it will terminate technical support for Windows 10 after October 14, 2025 in order to focus more on
Microsoft launches new version of Outlook for Windows: comprehensive upgrade of calendar functions
Apr 27, 2024 pm 03:44 PM
In news on April 27, Microsoft announced that it will soon release a test of a new version of Outlook for Windows client. This update mainly focuses on optimizing the calendar function, aiming to improve users’ work efficiency and further simplify daily workflow. The improvement of the new version of Outlook for Windows client lies in its more powerful calendar management function. Now, users can more easily share personal working time and location information, making meeting planning more efficient. In addition, Outlook has also added user-friendly settings, allowing users to set meetings to automatically end early or start later, providing users with more flexibility, whether they want to change meeting rooms, take a break or enjoy a cup of coffee. arrange. according to
Microsoft plans to phase out NTLM in Windows 11 in the second half of 2024 and fully shift to Kerberos authentication
Jun 09, 2024 pm 04:17 PM
In the second half of 2024, the official Microsoft Security Blog published a message in response to the call from the security community. The company plans to eliminate the NTLAN Manager (NTLM) authentication protocol in Windows 11, released in the second half of 2024, to improve security. According to previous explanations, Microsoft has already made similar moves before. On October 12 last year, Microsoft proposed a transition plan in an official press release aimed at phasing out NTLM authentication methods and pushing more enterprises and users to switch to Kerberos. To help enterprises that may be experiencing issues with hardwired applications and services after turning off NTLM authentication, Microsoft provides IAKerb and
Microsoft Edge Android version now provides Copilot translation function, and the Windows version is under small-scale testing
Apr 27, 2024 am 08:40 AM
According to news from this site on April 26, as we all know, Microsoft is currently trying its best to promote its AI assistant Copilot. In addition to the Copilot that comes with Windows 10/11, the Copilot function is also integrated in the Edge browser and Office. At present, Copilot still has weaknesses compared to AI tools such as GPT, but some of the functions it provides are also very practical for Windows users and Edge users, such as its own translation function. As discovered by @Leopeva64, Microsoft has added this feature to the Android version of the EdgeDev browser and is also testing it for a small number of desktop Edge users. This site points out that C
