SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reason for Migrating SQL 2012 to SQL 2014


Reason for Migrating SQL 2012 to SQL 2014

Author
Message
karthik M
karthik M
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3037 Visits: 2584
All,

We have recently migrated SQL 2008 DB to SQL 2012. We modified the queries/procedures to make use of new features ( from a developer perspective)

SQL 2014 is release now.

Apart from IN-memory OLTP, is there any useful things added in sql 2014 (FROM A Developer view) ? If not, what is the reason for Migrating SQL 2012 to SQL 2014?

karthik
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28155 Visits: 13268
SQL 2014 has not yet been released. (we're not yet in 2014 remember)

There is a public CTP available, but these things can still be riddled with bugs. Furthermore, you cannot install it on a server where another version of SQL Server has been installed.

What is interesting in this CTP? For now the in-memory OLTP and the clustered columnstore index, but that's about it.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
DBA From The Cold
DBA From The Cold
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2209 Visits: 1746
I'm quite looking forward to seeing the ability to extend the buffer pool to an SSD card.

Andrew
Andreas.Wolter
Andreas.Wolter
SSC Veteran
SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)

Group: General Forum Members
Points: 253 Visits: 1056
Even though SQL 2014 is by far not complete in CTP1 and more is to come, you should be ready for a new way of developing Datawarehouses - if In-Memory-OLTP is not enough "developer-stuff" for you.
Why is that?
Because it can be foreseen, that from that release on, ColumnStore will be the new standard storage-format for Facts as well as Dimensions - which is a big shift from anything before.

You can read some more on the reasons behind here: www.insidesql.org/blogs/andreaswolter/2013/06/sql-server-2014-columnstore-indexes-batch-mode-improvements


cheers,

Andreas

Andreas

---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41865 Visits: 32666
While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling reason to upgrade if you're on a system with issues in and around statistics.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28155 Visits: 13268
Grant Fritchey (7/17/2013)
While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling reason to upgrade if you're on a system with issues in and around statistics.



statistics engine?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41865 Visits: 32666
Koen Verbeeck (7/17/2013)
Grant Fritchey (7/17/2013)
While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling reason to upgrade if you're on a system with issues in and around statistics.



statistics engine?


Yeah, statistics generation is supposedly all rearranged & updated. Again, haven't tested it, so I've got nothing specific for you.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Erland Sommarskog
Erland Sommarskog
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2173 Visits: 872
I'm not sure that I know what Grant is talking about. There some changes to the optmizer, as described in Books Online:

Query plans

SQL Server 2014 includes substantial improvements to the component that creates and optimized query plans. To take advantage of these improvements new database applications should be developed using database compatibility level 120. Applications that are migrated from earlier versions of SQL Server should be carefully tested to confirm that good performance is maintained or improved. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).


I have not found further description to what these changes are, but I don't know think it's related to how statistics are generated.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41865 Visits: 32666
Erland Sommarskog (7/18/2013)
I'm not sure that I know what Grant is talking about. There some changes to the optmizer, as described in Books Online:

Query plans

SQL Server 2014 includes substantial improvements to the component that creates and optimized query plans. To take advantage of these improvements new database applications should be developed using database compatibility level 120. Applications that are migrated from earlier versions of SQL Server should be carefully tested to confirm that good performance is maintained or improved. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).


I have not found further description to what these changes are, but I don't know think it's related to how statistics are generated.


I must be misremembering reading this. I thought it was statistics. My mistake.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28155 Visits: 13268
Erland Sommarskog (7/18/2013)
I'm not sure that I know what Grant is talking about.


We all have that from time to time. :-D


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search