MS SQL Server 2008的主要新“核心”功能是什么？

I'm looking mainly at things like new SQL syntax, new kinds of locking, new capabilities etc. Not so much in the surrounding services like data warehousing and reports...

我主要关注新的SQL语法,新的锁定,新功能等等。在数据仓库和报告等周边服务中并没有那么多......

8 个解决方案

#1

Did you check the whitepaper on the website? SQL Server 2008 Overview.

你看过网站上的白皮书了吗? SQL Server 2008概述。

I cannot recall off the top of my head, but it atleast has a nice database to object linking functionality. They have geospatial types too, if you need to use those.

我不记得我的头脑,但它至少有一个很好的数据库来反对链接功能。如果你需要使用它们,它们也有地理空间类型。

#2

There's a great article on the new T-SQL features here (by SQL guru Itzik Ben-Gan). It covers

这里有一篇关于新T-SQL功能的精彩文章(由SQL大师Itzik Ben-Gan撰写)。它涵盖

Declaring and initializing variables

声明和初始化变量

Compound assignment operators

复合赋值运算符

Table value constructor support through the VALUES clause

表值构造函数支持通过VALUES子句

Enhancements to the CONVERT function

CONVERT功能的增强功能

New date and time data types and functions

新的日期和时间数据类型和功能

Large UDTs (GEOMETRY and GEOGRAPHY)

大型UDT(几何和地理)

The HIERARCHYID data type

HIERARCHYID数据类型

Table types and table-valued parameters

表类型和表值参数

The MERGE statement, grouping sets enhancements

MERGE语句,分组设置增强功能

DDL trigger enhancements

DDL触发器增强功能

Sparse columns
Filtered indexes
Large CLR user-defined aggregates

大型CLR用户定义聚合

Multi-input CLR user-defined aggregates

多输入CLR用户定义的聚合

The ORDER option for CLR table-valued functions

CLR表值函数的ORDER选项

Object dependencies
Change data capture

更改数据捕获

Collation alignment with Microsoft® Windows®

与Microsoft®Windows®进行整理校准

Deprecation

#3

Filestream blob storage is the biggest bonus to me

Filestream blob存储对我来说是最大的好处

#4

New separate types for Date and Time, instead of just Datetime

日期和时间的新单独类型,而不仅仅是日期时间

New geographic types for lattitude/longitude

纬度/经度的新地理类型

Change Data Capture is pretty neat if you're doing anything where auditing is important

如果您正在执行审计很重要的任何事情,那么Change Data Capture非常简洁

Configuration Servers, for maintaining multiple databases.

配置服务器,用于维护多个数据库。

That's what caught my attention at the Heroes Happen Here launch back in April.

这是引起我注意力于4月份在Heroes Happen Here发布时的注意力。

#5

HotAdd CPU. http://msdn.microsoft.com/en-us/library/bb964703.aspx

HotAdd CPU。 http://msdn.microsoft.com/en-us/library/bb964703.aspx

#6

white paper on SQL Server 2008

SQL Server 2008上的白皮书

This should cover most of the new features. I noticed the new date time data types and new security features.

这应涵盖大多数新功能。我注意到了新的日期时间数据类型和新的安全功能。

#7

Page compressiong sounds really nice to me. Haven't used it yet, though.

Page compressiong听起来对我很好。但是还没有用过它。

http://sqlblog.com/blogs/linchi_shea/archive/2008/05/11/sql-server-2008-page-compression-compression-ratios-from-real-world-databases.aspx

#8

Sparse indexing for those with lots of NULLs. Also the DATETIME2 data type that a lot of people have been waiting for 0001-01-01 through 9999-12-31.

具有大量NULL的稀疏索引。也是很多人一直在等待的0001-01-01到9999-12-31的DATETIME2数据类型。

#1