SqlHints.com

By Basavaraj Biradar

Skip to content
  • Performance Tuning
  • Sql Server Tutorial
  • Sql 2008
  • Sql 2012
  • Sql 2014
  • Sql 2016
  • All Articles
  • ABOUT BASAVARAJ

Tag Archives: What’s New in Sql Server 2012

New Features in Sql Server 2012

July 7, 2013Sql Server, Sql Server 2012New Feature in Sql Server 2012, Sql Server, SQL SERVER 2012, What's New in Sql Server 2012Basavaraj Biradar

Following are the some of the new features of the Sql Server 2012 which I have blogged. Click on the feature name to know it in detail with extensive examples:

[ALSO READ] New features in Sql Server 2014

SEQUENCE OBJECT
  • Introduction to SEQUENCE
  • SEQUENCE Limitations and Restrictions
  • SEQUENCE Cache Management and Internals
THROW
  • THROW Statement
EXECUTE WITH RESULT SETS Option
  • EXECUTE Statement with WITH RESULT SETS
    option in SQL SERVER 2012
CONVERSION FUNCTIONS STRING FUNCTIONS
  • PARSE
  • TRY_PARSE
  • TRY_CONVERT
  • CONCAT
  • FORMAT
LOGICAL FUNCTIONS DATE AND TIME FUNCTIONS
  • CHOOSE
  • IIF
  • EOMONTH
  • DATEFROMPARTS
  • DATETIMEFROMPARTS
  • SMALLDATETIMEFROMPARTS

[ALSO READ] New features in Sql Server 2014
New Features in Sql Server 2008

Share this:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X
  • Click to email a link to a friend (Opens in new window) Email
  • Click to print (Opens in new window) Print
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to share on Tumblr (Opens in new window) Tumblr
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to share on Pinterest (Opens in new window) Pinterest
View all 3 comments

Subscribe to Blog via Email

Join 1,993 other subscribers

Privacy Policy

Sqlhints.com Privacy Policy

Disclaimer

This is my personal blog site. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MS Books On Line and/or MSDN/TechNet. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.

Differences…

  • Varchar vs NVarchar
  • Varchar vs Varchar(MAX)
  • Char vs Varchar
  • Text vs Varchar(Max)
  • Union vs Union All
  • DateTime vs DateTime2
  • SET QUOTED_IDENTIFIER ON vs SET QUOTED_IDENTIFIER OFF
  • Stored Procedure vs User Defined Function
  • Primary Key vs Unique Key
  • RAISERROR vs THROW
  • Temporary Table vs Table Variable
  • Len() vs Datalength()
  • Sequence vs Identity
  • DATEDIFF vs DATEDIFF_BIG
  • LEFT JOIN vs LEFT OUTER JOIN
  • RIGHT JOIN vs RIGHT OUTER JOIN
  • JOIN vs INNER JOIN
  • LEFT OUTER JOIN vs RIGHT OUTER JOIN
  • SMALLDATETIME vs DATETIME

Categories

  • 101 Performance Tuning Tips and Tricks (8)
  • C# (1)
  • Index (1)
  • Sql Server (199)
    • CONSTRAINTS (1)
    • Differences (23)
    • DMVS (3)
    • Errors (5)
    • Exception Handling (4)
    • Performance Optimization (10)
      • Common Mistakes (3)
    • Scripts (29)
    • Sql Server 2005 (2)
    • SQL Server 2008 What's New (9)
    • Sql Server 2012 (18)
      • Functions (12)
        • Conversion Functions (3)
        • Date and Time Functions (4)
        • Logical Functions (2)
        • String Functions (2)
    • Sql Server 2014 (4)
      • Hekaton (3)
      • In-Memory OLTP (3)
    • Sql Server 2016 (27)
    • Sql Server Tutorial (8)
    • Stored Procedure (2)
    • System Stored Procedures (1)
    • Tips/Tricks (19)
    • User Defined Function (1)
    • Views (1)

Archives

Sql Server Tutorial

Variables and Data Types
Working with Databases
Working with Tables
Constraints - PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, and DEFAULT
UNION AND UNION ALL
Stored Procedures
User Defined Functions
Views
Exception Handling
New Features in Sql Server 2008
New Features in Sql Server 2012
New Features in Sql Server 2014

Recent Posts

  • Indexes in Sql Server – Part I June 29, 2020
  • How to get the Length of a String in Sql Server? February 29, 2020
  • How to get Day of Year from date in Sql Server September 1, 2018
  • Do we need to include a Clustered Index Column too in a Non-Clustered Index to make it as a Covering Index for a Query? Tip 7: Sql Server 101 Performance Tuning Tips and Tricks May 6, 2018
  • How to Inspect the content of a DATA PAGE or INDEX PAGE ? Tip 6: Sql Server 101 Performance Tuning Tips and Tricks May 5, 2018
  • How to get an Index’s Root Page, Intermediate Pages and Leaf Pages Information? Tip 5: Sql Server 101 Performance Tuning Tips and Tricks May 3, 2018
  • How to find the list of all Pages that belongs to a Table and Index? Tip 4: Sql Server 101 Performance Tuning Tips and Tricks April 30, 2018
  • Does the order of Columns in a Composite Index matters? Tip 3: Sql Server 101 Performance Tuning Tips and Tricks October 1, 2017
  • Evils of using function on an Index Column in the WHERE clause– Tip 2: Sql Server 101 Performance Tuning Tips and Tricks September 10, 2017
  • Implicit conversion an evil for Index – Tip 1: Sql Server 101 Performance Tuning Tips and Tricks September 2, 2017

Tags

  • APPLY in SQL
  • Common Table Expression
  • Conversion Functions
  • CTE
  • DATEADD
  • Date and Time Functions
  • Error Message
  • Filtered Index
  • Foreign Key Constraint
  • FORMAT
  • Hekaton
  • JSON
  • JSON in Sql
  • JSON in Sql Server
  • JSON in Sql Server 2016
  • Msg 13608
  • New Feature in Sql Server 2012
  • OBJECT_ID()
  • Performance
  • Performance Tuning
  • Performance Tuning Tips and Tricks
  • PIVOT
  • Sequence
  • Sql
  • Sql 101 Performance Tuning
  • Sql 2016
  • Sql Common Table Expression
  • Sql CTE
  • Sql Server
  • Sql Server 2008
  • SQL SERVER 2012
  • SQL SERVER 2014
  • Sql Server 2014 CTP2
  • Sql Server 2016
  • Sql Server Performance Tips and Tricks
  • Sql Server Performance Tuning Tip
  • Sql Server Tutorial
  • Stored Procedure
  • sys.objects
  • sys.sysobjects
  • System Versioned Table
  • System Versioned Temporal Table
  • Temporal Table
  • TIps/Tricks
  • VARCHAR
Proudly powered by WordPress