July 16, 2013 at 3:29 am
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
July 16, 2013 at 3:44 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 6:10 am
I'm quite looking forward to seeing the ability to extend the buffer pool to an SSD card.
Andrew
July 16, 2013 at 8:24 am
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
July 17, 2013 at 5:23 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 17, 2013 at 5:34 am
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 17, 2013 at 5:53 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 18, 2013 at 2:42 am
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.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 18, 2013 at 8:44 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 19, 2013 at 12:33 am
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. 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 19, 2013 at 3:50 pm
There is a "product guide" which you can download, which gives some more information:
Query-processing enhancements
New cardinality estimator
The cardinality estimator improves the querying process and offers the following benefits:
Earlier statistics invalidation
Improvements to trigger the automatic update of statistics enable better query results, because statistics invalidation occurs earlier in SQL Server 2014. Faster and more frequent refreshes of statistics are possible because the invalidation threshold has been set to 20 percent of a single partition.
Parallel SELECT INTO
Data-loading is significantly faster because data insertion into a table can occur in parallel through the SELECT INTO operation.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 30, 2013 at 10:19 am
Andreas Wolter-332291 (7/16/2013)
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
Quick question on this, with the 2012 Columns stores they where memory intensive in during thier creation and also took longer than a Clustered index to apply.
Is this still the case?
_________________________________________________________________________
SSC Guide to Posting and Best Practices
July 30, 2013 at 10:44 am
Jason-299789 (7/30/2013)
Andreas Wolter-332291 (7/16/2013)
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
Quick question on this, with the 2012 Columns stores they where memory intensive in during thier creation and also took longer than a Clustered index to apply.
Is this still the case?
Hi
I haven't tested and compared it directly, but the memory handling has been improved a lot, so I would expect it to behave better in comparison. But I have no idea by which extend
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
August 2, 2013 at 8:17 am
Andreas,
Thanks for the feedback, it will be interesting to see how this goes, I noticd in your blog that some of the restrictionin regards to updated data have also been removed which may make if feasible moving forward, providing the overhead isnt too great.
I think I need to download and install a copy at some point to have a dive around.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply