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

4
Liked

2
Comments

SQL Server 2012 - OVER Clause is enhanced with ROWS/RANGE Clause to limit the rows

In SQL Server 2012, one of the addition to OVER clause is, ROWS/RANGE Clause. In general, when we apply aggregate functions in over clause, it will apply to all rows in that group/partition. Suppose, if we wants to restrict the number of rows, it involv...

Ramireddy Posted on Dec 20 2011 11:19PM
Profile · Facebook · Twitter

4
Liked

0
Comments

SQL Server 2012 - OVER Clause is enhanced to apply aggregate functions while applying "Order By"

Before SQL Server 2012, We can't use "Order By" clause, while we are using aggregate functions in OVER clause. Suppose, to calculate company-wise cumulative revenues per year, we can't take the advantage of aggregate operators with OVER clause. Below ...

Ramireddy Posted on Dec 20 2011 3:15AM
Profile · Facebook · Twitter