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»»

SQL Server 2014 - Service Pack 1? Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 10:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 1:31 AM
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
Post #1567767
Posted Tuesday, May 6, 2014 12:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567783
Posted Tuesday, May 6, 2014 6:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
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.


---------------------------------------------------------------------

Post #1567904
Posted Tuesday, May 6, 2014 7:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 6:53 AM
Points: 13,890, Visits: 28,285
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
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 #1567923
Posted Wednesday, May 7, 2014 3:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:18 AM
Points: 2,886, Visits: 3,256
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1568340
Posted Monday, May 12, 2014 4:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, October 19, 2014 10:21 AM
Points: 31, Visits: 513
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? : )
Post #1570077
Posted Tuesday, May 13, 2014 7:36 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:25 AM
Points: 301, Visits: 595
They might release it in November with SQL 2012 SP2.

MCSA SQL Server 2012
Post #1570303
Posted Tuesday, May 13, 2014 7:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
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 LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1570315
Posted Tuesday, May 13, 2014 7:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:25 AM
Points: 301, Visits: 595
http://redmondmag.com/articles/2014/02/14/sp2-for-sql-server-2012.aspx


MCSA SQL Server 2012
Post #1570328
Posted Wednesday, June 11, 2014 3:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:44 PM
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
Post #1579832
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse