Home > SQL Server > What’s new in SQL SERVER 2014 Services – SQL SERVER

What’s new in SQL SERVER 2014 Services – SQL SERVER


We might have installed the new version SQL Server 2014 in our system to explore the new features and we are excited to jump-start with the key features. But, before we start anything new we have to spend some time to learn about it. This blog post is to highlight the new features in each services of SQL Server 2014

Installation -

In this SQL Server 2014 CTP1 release, SQL Server Setup no longer installs SSDT BI. The Visual Studio 2012 version of SSDT BI is now available as a separate web download from the Microsoft Download center.

SQL Server Integration Services -
This release does not contain new features.

SQL Server Reporting Services -
This release does not contain new features.

SQL Server Analysis Services / Power View
 Functionality included to access Multidimensional Models in SQL Server 2014 Reporting Services (in SharePoint mode) and it does not support in Excel 2013 Power View add-in. This was first introduced it SQL Server 2012 Service Pack 1 Cumulative Update 4.

SQL Server Database Engine Enhancements -

1. In-Memory optimized table and stored procedure design.

2. AlwaysOn enhancements, secondary replicas count is increased from 4 to 8 and new functions and DMVs are added for efficient troubleshooting and to get other valuable information quickly.

3. Managing the lock priority of online operations – Additional partition switching and index rebuild operations can now be performed and it allows us to configure the termination of blocking processes.

4. New features added for Columnstore indexes such as updatable clustered columnstore index,  information about columnstore indexes in SHOWPLAN and  compress the specified partitions of a columnstore index.

5. Buffer Pool Extension provides the seamless integration of solid-state drives (SSD) as a nonvolatile random access memory (NvRAM) extension to improve IO throughput.

6. Query optimizer have been improved to produce optimized query plan and it is available for the database compatibility level 120.

7. T-SQL Enhancement : Inline specification of CLUSTERED and NONCLUSTERED indexes is now allowed for disk-based tables.

8. T-SQL Enhancement: SELECT … INTO query is now operate in parallel and it is available for the database compatibility level >= 110.

9. System Table Enhancements:

  • sys.xml_indexes : new columns added
  • sys.dm_exec_query_profiles : shows real-time query progress
  • sys.column_store_row_groups : gives information about clustered columnstore index
About these ads

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

Follow

Get every new post delivered to your Inbox.

Join 306 other followers

%d bloggers like this: