What is New - What is new in SQL Server 2012

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	What is New

Upload Image

Close it

Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators


	Like

Invite Friends

Top Categories · View All

TSQL Enhancements	28
Discontinued Features	16
SSIS Enhancements	10
SSMS Enhancements	10
Database Engine	10
Database Administration	8
Security	3
Full Text Search	2
DataTime	1
Breaking Changes	1

Browse by Tags · View All

Denali	82
SQL Server 2012	79
SSIS	9
SSMS Enhancements	9
Analytic Functions	8
Usability Enhancements	5
SQL11	4
TSQL	4
Security	3
Database Engine	3
Datetime	3
Query Hints	2
OVER Clause	2
DMV	2
Groups	2
Dynamic Management Functions	2
DMF	2
System stored procedures	2
DBA	2
FTS	2

Browse by Release · View All

All	58
RC0	20
SQL Server 2012 Denali	2
CTP3	2
SQL Server Denali	1

What is new in SQL Server 2012 - Denali

Features · Categories · Submit a feature · Most Liked · Most Discussed · Info · News · Fans (73) · Preferences

1
Liked

0
Comments

SQL Server 2012 Denali - Columnstore Indexes

The SQL Server columnstore index feature, code-named **Apollo**, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 in many cases by a factor o...

Jacob Sebastian Posted on Nov 29 2011 5:34AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali - New Dynamic Management Function (DMF) - sys.dm_exec_describe_first_result_set_for_object

Yet another Dynamic Management Function (DMF) introduced by SQL Server 2012 is `sys.dm_exec_describe_first_result_set_for_object`. The functionality is the same as [`sys.dm_exec_describe_first_result_set`][1], except that this function takes an `Object ...

Jacob Sebastian Posted on Nov 29 2011 4:58AM
Profile · Blog · Facebook · Twitter

2
Liked

0
Comments

SQL Server 2012 Denali - New Dynamic Management Function (DMF) - sys.dm_exec_describe_first_result_set

SQL Server 2012 introduces a new Dynamic Management Function (DMF) which allows us to examine the metadata of the result set of a query, stored procedure etc. This is very handy to examine the number of columns, column names, data types etc which is ot...

Jacob Sebastian Posted on Nov 29 2011 1:59AM
Profile · Blog · Facebook · Twitter