sql server 2012

5 posts

SQL Server 2012 Analytical Functions, Part 2 of 2

This article is the second and the final article in the series on the new analytical functions introduced in SQL Server 2012. The new analytical functions are a great addition to SQL Server 2012. But I personally feel that SQL Server still has a bit to catch up with the capabilities of other RDBMS products like Oracle or DB2 or Sybase when it comes to analytical functions.

SQL Server 2012 Analytical Functions, Part 1 of 2

This article is Part 1 of the series which describes the new analytical functions introduced with SQL Server 2012. This article focuses only on the newly added analytical functions introduced in SQL Server 2012.

New in built Functions in SQL Server 2012

Each version of SQL Server brings new set of features,utilities and enhancements.SQL Server 2005 brought amazing features like ranking functions,Common Table Expression,Service Broker,Table partitioning,DMV’s and new type of Indexes which made life of a Developer and a DBA much easy.SQL Server 2008 and 2008R2 was quite a disappointment in terms of enhancements to TSQL functions when compared to its predecessor SQL Server 2005 but had wonderful new features like Database mirroring,Resource Governor,Policy Management,Data collection,Extended Events etc.

SEQUENCE Objects in SQL Server 2012

In this article we would look into an another cool new feature of SQL Server 2012 called “SEQUENCES”. If you are familiar with Oracle you might know that this feature has been available since Oracle 8i but is new to the SQL Server world.

Partially Contained Databases in SQL Server 2012

The biggest problem with SQL Server for a very long time has been that databases on an instance are always tightly coupled to it. So once you move your database to a different SQL server instance the database will always face compatibility issues though the target and source server instances were of the same version and Service packs.