February 2007 - Posts

• Leaking roof and file shrinking

  Shrinking and growing database files cost you resources and have other side effects as well. I have a technical description http://www.karaszi.com/SQLServer/info_dont_shrink.asp if you want to get into details about it. Sure, you can have valid reasons Read More... Posted Sunday, February 25, 2007 11:31 AM by TiborKaraszi | 1 Comments Filed under: Maintenance

• Review your Maint Plans after sp2!

  You might have heard that Maint Plans has had some work on them in sp2. One enhancement is that the Maintenance Cleanup Task now allow for removing of backup files based on hours. This can lead to undesired too early cleanup if you upgraded such a plan. Read More... Posted Sunday, February 25, 2007 11:03 AM by TiborKaraszi | 0 Comments Filed under: Maintenance

• Having fun with new RESTORE options in 2005

  You might know that we have some new options for backup and especially restore in SQL Server 2005. Below script was inspired by a newsgroup post regarding not being able to restore an old readonly filegroup backup into a new database. Here is what I wanted Read More... Posted Friday, February 09, 2007 2:32 PM by TiborKaraszi | 0 Comments Filed under: Backup

• SQL Server Database Publishing Wizard

  The SQL Server Database Publishing Wizard (DPW) is an interesting new tool. It was designed for ease working with SQL Server when you have someone hosting your web-site and you want to publish your database. Sure, you can do backup and restore, but that Read More... Posted Saturday, February 03, 2007 11:02 AM by TiborKaraszi | 0 Comments Filed under: Tools

• Best Practice Analyzer for 2005

  I'm glad to see that the tool Best Practice Analyzer is finally coming in a SQL Server 2005 version. This will be released with sp2, which is scheduled for Q1 2007. Read more at http://blogs.msdn.com/sqlrem/archive/2007/01/12/SP2-and-BPA-FAQ.aspx . Share Read More... Posted Saturday, February 03, 2007 10:51 AM by TiborKaraszi | 0 Comments Filed under: Tools