James Moore

Divisional Manager for DBA Tools - Red Gate Software

SQL Server 2005 SP2 - Someone bogged up big time

Published Thursday, March 01, 2007 7:59 PM

Thought I better post this incase you havn't seen it -

If you are using SQL Server 2005 maintainance tasks and upgrade to sp2 be ready for a nasty suprise. If you have a Maintenance cleanup task or a history clean up task your units which used to be measured in days are now measured in hours..

See: http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx for more information..

- James

by James

Comments

No Comments
New Comments to this post are disabled


















<March 2007>
SuMoTuWeThFrSa
25262728123
45678910
11121314151617
18192021222324
25262728293031
1234567
Niklaus Wirth: Geek of the Week
 It is difficult to begin to estimate the huge extent of the contribution that Niklaus Wirth has made to... Read more...

Building an Exchange Server 2007 environment
 Of course, changing a 32,000 mailbox system, based in 40 Exchange Servers, to a centralised 25,000... Read more...

Manage Stress Before it Kills You
 The key to a long career in IT is in learning how to cope adaptively with stress. Matt Simmons, like... Read more...

Expecting the Worst
 Optimists are often disappointed Read more...

To Boldly Ask IT for Development Work
 Phil has always been mystified by the way that, in Science-Fiction films, the crew of space-ships are... Read more...