Transcript Yukon – What is New

Yukon – What is New
Rajesh Gala
Yukon – What is new
.NET Framework Programming
Data Types
Exception Handling
Batches
Databases
Database Engine Administration
Full-Text Search
Indexes
Meta Data
Query Processor
Tables
Table and Index Partitioning
Triggers and Event Notification
Views
Yukon – What is new
.NET Framework Programming
You can now create a database object inside an
instance of SQL Server that is programmed
against an assembly created in the Microsoft
.NET Framework common language runtime
(CLR). Stored procedures, functions, triggers,
user-defined types, and user-defined aggregate
functions can leverage the rich programming
model provided by the CLR.
Yukon – What is new
Batches
SQL Server "Yukon" Beta 1 introduces a new
feature called multiple active result sets (MARS).
MARS allows client drivers to have more than
one pending request per connection.
Yukon – What is new
Data Types
SQL Server "Yukon" Beta 1 provides new data
types and enhances several of the existing SQL
Server data types.
Yukon – What is new
Databases
By using the new options in the following DDL
statements, you can work with new features,
such as database views, database mirroring, and
the snapshot isolation framework.
Yukon – What is new
Database Engine Administration
Database administrators have enhanced tools
for administering the database engine.
Yukon – What is new
Exception Handling
Transact-SQL has the TRY and CATCH
constructs that allow you to handle transaction
abort errors that would otherwise have resulted
in the termination of a batch.
Yukon – What is new
Full-Text Search
Managing full-text search is streamlined and
more efficient. You can use new DDL statements
(instead of system stored procedures) to create,
manage and modify, and drop full-text indexes
and catalogs. You can also attach and detach
full-text
Yukon – What is new
Indexes
ALTER INDEX, a new Transact-SQL DDL
statement, is introduced for reorganizing and
rebuilding relational and XML indexes. The
CREATE INDEX statement has been enhanced
to support XML index syntax, partitioning, and
included (nonkey) columns. Several index
options have been added including ONLINE,
which allows concurrent user access to the
underlying data during some index operations.
Yukon – What is new
Meta Data
SQL Server "Yukon" Beta 1 introduces catalog
views. Catalog views change the way in which
users can access system meta data information.
This beta release also introduces two new virtual
tables.
Yukon – What is new
Query Processor
The database engine has been enhanced with
query processing tools that developers can use
to manipulate data and get complex information
from the database.
Yukon – What is new
Tables
You can create and alter tables with columns using new
data types, which include xml, varchar(max),
nvarchar(max), varbinary(max), date, time,
utcdatetime, and CLR user-defined types. Computed
columns can be persisted for use in creating indexes on
them. Cascading referential integrity constraints are
enhanced by specifying SET NULL and SET DEFAULT in
addition to CASCADE and NO ACTION. The combined
width of variant data type columns can now exceed 8
kilobytes (KB) per page. Very large tables and indexes
(greater than 128 extents) can be dropped faster than in
earlier versions of SQL Server because of a deferred
allocation unit drop mechanism.
Yukon – What is new
Table and Index Partitioning
You can partition tables and indexes by dividing them into units that
might be spread across more than one filegroup in a database.
Partitioned tables and indexes are partitioned horizontally so that
groups of rows are mapped into individual partitions. Operations
performed on the data, such as queries, are executed as if the
entire table or index is a single entity.
Partitioning can make:
Querying large tables or indexes faster and more efficient on
multiple-CPU computers.
Large tables or indexes more manageable by allowing quick and
efficient access to or management of data subsets, while
maintaining the integrity of the overall collection.
Yukon – What is new
Triggers and Event Notifications
SQL Server "Yukon" Beta 1 introduces DDL triggers and event
notifications.
DDL triggers, like standard triggers, execute stored procedures in
response to an event. But unlike standard triggers, DDL triggers
execute in response to DDL statements (primarily statements that
begin with CREATE, ALTER, and DROP). DDL triggers are used for
administrative tasks, such as auditing and regulating database
operations.
Event notifications execute in response to DDL and data
manipulation (DML) statements, as well as trace events, but do not
execute stored procedures. Instead, event notifications send
information about a server event to a service broker. You can use
event notifications to log and review changes or activity that occurs
on the database.
Yukon – What is new
Views
The restrictions to updating data through a view
have been relaxed, and statistics can be created
on nonindexed views for query optimization.
Yukon – What is new
Demo
XML Data Type
.Net Framework Programming
Yukon Report Server