Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reason for Migrating SQL 2012 to SQL 2014 Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 3:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:23 AM
Points: 2,025, Visits: 2,521
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
Post #1474041
Posted Tuesday, July 16, 2013 3:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 13,294, Visits: 11,085
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474043
Posted Tuesday, July 16, 2013 6:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 1,306, Visits: 1,139
I'm quite looking forward to seeing the ability to extend the buffer pool to an SSD card.

Andrew
Post #1474084
Posted Tuesday, July 16, 2013 8:24 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 6:14 AM
Points: 153, Visits: 980
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
Post #1474153
Posted Wednesday, July 17, 2013 5:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1474501
Posted Wednesday, July 17, 2013 5:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 13,294, Visits: 11,085
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474506
Posted Wednesday, July 17, 2013 5:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1474515
Posted Thursday, July 18, 2013 2:42 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:20 PM
Points: 807, Visits: 725
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
Post #1474937
Posted Thursday, July 18, 2013 8:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1475257
Posted Friday, July 19, 2013 12:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 13,294, Visits: 11,085
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.




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

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1475283
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse