What is New - What is new in SQL Server 2012 - Denali

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

2
Liked

1
Comments

New Performance Counters added and some removed

SQL Server 2012 (Denali) introduced a number of new performance counters and removed a few that were available with the previous versions of SQL Server. Several `AWE` related counters (such as *AWE lookup maps/sec*, *AWE unmap pages/sec* etc) were re...

Jacob Sebastian Posted on Nov 28 2011 8:48PM
Profile · Blog · Facebook · Twitter

4
Liked

0
Comments

Contained Databases allow you to move a database to a new location along with all the dependencies

One of the challenges involved in moving/copying databases to a new location (prior to SQL Server 2012) was copying the dependencies along with the database. External dependencies such as login names, linked servers etc are not automatically copied to t...

Jacob Sebastian Posted on Nov 28 2011 8:33PM
Profile · Blog · Facebook · Twitter

2
Liked

0
Comments

CONCAT Function to concatenate two or more strings

CONCAT function can be used to concatenate two or more strings. This function is available before in other databases like Oracle,MySQL etc. This feature will offer below advantages over standard concatenation operator(+) - If any of the string is nul...

Ramireddy Posted on Nov 28 2011 12:47PM
Profile · Facebook · Twitter

4
Liked

0
Comments

Support for SEQUENCE type to generate sequential numbers

The new SEQUENCE type in SQL Server 2012 will allows you to create sequential numbers. In general identity columns can be used to uniquely identify records in a table. But if we wants to maintain identity columns across multiple tables, or if we need th...

Ramireddy Posted on Nov 28 2011 10:27AM
Profile · Facebook · Twitter

10
Liked

0
Comments

Enhancements to EXECUTE statement: WITH RESULT SETS

SQL Server 2012 enhanced the `EXECUTE` statement with an additional clause `WITH RESULT SETS` which allows you to convert/alter the columns and data types of the results produced by the `EXECUTE` statement. Assume that your stored procedure returns an ...

Jacob Sebastian Posted on Nov 28 2011 8:27AM
Profile · Blog · Facebook · Twitter

2
Liked

2
Comments

Support for Pagination using ORDER BY along with OFFSET and FETCH NEXT

The new pagination support allows you to write queries that can return rows from specific position of the result set. For example: the following query returns rows 20 to 30 from the result set. SELECT * FROM Customers ORDER BY CustID ...

Jacob Sebastian Posted on Nov 28 2011 7:40AM
Profile · Blog · Facebook · Twitter

Previous | 11 Next