SQL Server Performance

SQL 2005 sp2

Discussion in 'SQL Server 2005 General DBA Questions' started by Akthar, Mar 26, 2007.

  1. Akthar New Member

    hI gUYS

    Any feedback on the SP 2 ???



    AKTHAR
  2. Luis Martin Moderator

  3. MohammedU New Member

  4. Akthar New Member

    would you guys recommend going sp2 on live production Server???

    AKTHAR
  5. thomas New Member

    Yes. It'll be fine.

    the only issue I have found so far is that subqueries are no longer allowed in Output clauses - this broke one SP in one of our applications. This was caught in testing fortuantely. This change is very well hidden in the SP2 books online update at the very bottom of the OUTPUT topic. It's obscure though and unlikely to affect many people I wouldn't have thought.
  6. MohammedU New Member

    No issues... but if downloaded SP2 before 5th March don't use it...
    Down load again to get the hotfix included SP2...



    MohammedU.
    Moderator
    SQL-Server-Performance.com
  7. dineshasanka Moderator

    Some of our guys experiencing issues in report service after installing SP2. but not yet conformed by MS

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  8. Akthar New Member

    Thanks for these infos guys

    AKTHAR
  9. satya Moderator

    If you are using database maintenance plans on the SQL server where SP2 is applied or thinking to apply then ensure to apply the patch for DB maint.plans too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  10. MohammedU New Member

  11. Akthar New Member

    is the Db maint plan patch not part of the SP2

    AKTHAR
  12. satya Moderator

    No after the SP2 release MS has released this patch (which is an unofficial SP2a).

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  13. MohammedU New Member

    I believe it is included in SP2, If you download SP2 after 3/5/2007...
    The maintenance plan pathc was related to backup retention issue but the following might be after sp2 patch...

    SP2 - Check Database Task on Maint only ever does master
    http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx



    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  14. MohammedU New Member

    Just now I got an email from Tony Rogerson (SQL User Group) cofirming that the following one post patch bug...
    SP2 - Check Database Task on Maint only ever does master
    http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx

    We have recently seen the release of SP2 and SP2a for SQL Server 2005. SP2a was released due to a bug in maintenance plans You can read the details of the bug here Maintenance Plan Changes in SQL Server 2005 SP2 the re-released service pack here SQL Server 2005 Service Pack 2 Rereleased as well as details of an outstanding bug (I mean one thats not fixed rather than a really good one) here SP2 - Check Database Task on Maint only ever does master. If you want to understand this more then I suggest you come to the usergroup meeting in April.


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  15. satya Moderator

    Thats why in MS community it is called unofficial SP2a [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
  16. MohammedU New Member

    After few weeks it may be called 2b OR 2c.....[<img src='/community/emoticons/emotion-2.gif' alt=':D' />] <br />Main reason for job security [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  17. satya Moderator

    May be or may not be, they are preparing for SP3 CTP and might be middle of this year.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  18. MohammedU New Member

    Good to know...<br />Looks like it is one news from MVP coference <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />

Share This Page