Click here to monitor SSC
A service from Red Gate

in
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in | Join | Help
Home Blogs Forums
Blogs Home > James Moore > SQL Server 2005 SP2 - Someone bogged up big time

James Moore

Divisional Manager for SQL 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
Latest articles
Backups, What Are They Good For?
 We've heard the confessional story from Pixar that Toy Story 2 was almost lost due to a bad backup, but... Read more...

C# Async: What is it, and how does it work?
 The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is... Read more...

Handling Deadlocks in SQL Server
 In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan... Read more...

SQL VIEW Basics
 SQL Views are essential for the database developer. However, it is common to see them misued, or... Read more...

The PoSh DBA: Grown-Up PowerShell Functions
 Laerte goes step-by-step through the process of tidying up and making more reusable an untidy... Read more...