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


SQL Server 2014 - Service Pack 1?


SQL Server 2014 - Service Pack 1?

Author
Message
kevinchow34
kevinchow34
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 4
Hi there

I am planning to migrate from SQL2008R2 --> SQL2014 but my team mates have concerns about migration of MS products without service pack release.

Do anyone knows when SP1 for SQL2014 is going to be released?


Cheers
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63992 Visits: 13298
It might take a while.
The SQL Server team has the tendency lately to release more and more cumulative updates, and less service packs.
For SQL Server 2012, there's still only sp1.

Waiting for the service pack to migrate though is a bit old-fashioned ;-)


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
george sibbald
george sibbald
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25254 Visits: 13701
Koen Verbeeck (5/6/2014)
It might take a while.
The SQL Server team has the tendency lately to release more and more cumulative updates, and less service packs.
For SQL Server 2012, there's still only sp1.

Waiting for the service pack to migrate though is a bit old-fashioned ;-)


+1 on this even though I have old fashioned tendencies myself.

If I was you and I was going through a thorough testing cycle I would apply the CU previous to the latest one (unless the latest CU fixes a problem I know I have). This is a pretty safe stance.

---------------------------------------------------------------------
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)SSC Guru (100K reputation)

Group: General Forum Members
Points: 100061 Visits: 33014
I'm with everyone else. I wouldn't suggest waiting for SPs at this point. There have just been fewer and fewer of them. I suspect they may be going the way of the dodo. However, there has already been a Cumulative Update (CU) for SQL Server 2014. That might help calm the fears of your co-workers.

----------------------------------------------------
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
EdVassie
EdVassie
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14383 Visits: 3904
We went live with SQL2014 CTP2 for our BI servers. For the stuff that existed in SQL2008R2 we have not noticed any problems. We are deferring the use of Hekaton until we have upgraded to RTM and CU1, but this is due to work prioritisation and not to concerns with the product.

We are using the BufferPool Extension feature, which has shifted over 90% of our database IO from spinning disk to SSD and given a good performance boost.

For any new installation of SQL2014 I would recommend you go direct to CU1. You have to test the environment whatever you do, and CU1 has a lot of useful fixes.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
wBob
wBob
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 576
Superstitious, anecdotal reasons for not upgrading, OR known workload, trialled extensively on comparable proof-of-concept kit? Hide until 2017, OR clearly attempt to identify positives and negatives. Specific tests for specific features to get the best from the new version of the product, eg In-memory OLTP, Buffer-pool extension, cardinality estimator changes, writeable clustered columnstore etc in conjunction with your business-critical queries. Positive and negative behaviour changes identified. Workarounds identified for regressions where possible. Technical debt and/or connect items logged for items that cannot be resolved.

Evidence-based go/no-go decision based on the "balance". Maybe? : )
lkennedy76
lkennedy76
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3514 Visits: 919
They might release it in November with SQL 2012 SP2.

MCSA SQL Server 2012
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63992 Visits: 13298
It's the Database!!! (5/13/2014)
They might release it in November with SQL 2012 SP2.


Any resource on that?


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
lkennedy76
lkennedy76
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3514 Visits: 919
http://redmondmag.com/articles/2014/02/14/sp2-for-sql-server-2012.aspx

MCSA SQL Server 2012
cmwahlqu
cmwahlqu
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 138
Crazy, I was told Nov. by multiple MSFT engineers, and then BOOM.....http://www.microsoft.com/en-us/download/details.aspx?id=43340
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