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
Raw Materials: Mirror, Mirror, on the Desk
 Seeing ourselves as we see ourselves. Read more...

Planning for Disaster
 There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare... Read more...

Transparent Data Encryption
  Transparent Data Encryption is designed to protect data by encrypting the physical files of the... Read more...

Software Piracy in Pakistan
 Alamzeb Khan, our Simple-Talk correspondent in Pakistan, goes undercover to discover the true scale of... Read more...

Implementing Cluster Continuous Replication, Part 3
 Cluster continuous replication (CCR) uses log shipping and failover to provide a more resilient email... Read more...