Click here to monitor SSC
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
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 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
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16453 Visits: 13205
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?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
george sibbald
george sibbald
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6326 Visits: 13687
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
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17592 Visits: 32265
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
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3146 Visits: 3816
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. 1 Dec 2016: now over 39,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 Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 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
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

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

MCSA SQL Server 2012
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16453 Visits: 13205
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?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
lkennedy76
lkennedy76
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

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

MCSA SQL Server 2012
cmwahlqu
cmwahlqu
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 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