Home > SQL Denali > Database performance and Scalability enhancements – Denali CTP 3

Database performance and Scalability enhancements – Denali CTP 3


As we all know that the SQL Server Denali came up with lot of changes start form the installation, GUI, features to huge data warehouse performance capability. But, there is a special area where database professionals focus much. It is performance. In this release Microsoft SQL Server team introduced or enhanced 3 features.

1. Number of table Partitions extended up-to 15000

2. Additional data types for online index rebuild

3. Columnstore Index – The most powerful feature for now and future

Introduction

Increased, number of table partition

Unlike the older limitation in creating table partition to only 1000 numbers by default. SQL Server Denali has 15000 table partition by default. So, database professional has plenty of rooms to hold data for a large tables. At the same time we should use this with caution by keeping database maintenance in mind.

Demonstration (Watch and Learn)

Additional Data Types for online indexing

varchar(max), nvarchar(max), and varbinary(max)  columns are now eligible for the online index rebuilding.

Demonstration (Watch and Learn)

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: