Browse by Tags

• Backup
• General
• Integration
• kba
• plan
• services
• SQL Server
• ssis
• SSMS
• Tools

• Updates of Ola Hallengren's maint procedures

  Ola Hallengren has updated his maint procedures. Support for SQL Server 2008 and some bug fixes. Check them out at: http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html Share this post: email it! | bookmark it! | digg it! | reddit! | kick Read More... Posted Saturday, August 23, 2008 5:49 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance

• More maint procedures

  A few months ago, I blogged about a simple procedure to do backup ( http://sqlblog.com/blogs/tibor_karaszi/archive/2007/09/25/tsql-script-to-do-backup-like-maintenance-plans.aspx ). Just to let you know that Ola Hallengren has some of his own. Much more Read More... Posted Friday, January 11, 2008 7:57 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup

• TSQL script to do backup like Maintenance Plans

  This is frequently asked question, both in forums, as well as in class: How can I though TSQL create new backup files for each backup and have date and time in the file names? The reason for above is most often that you want a higher degree of customization Read More... Posted Wednesday, September 26, 2007 2:20 AM from Tibor Karaszi | (Comments Off) Filed under: Maintenance, Backup

• On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More... Posted Friday, August 24, 2007 6:15 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Maintenance, Integration, SSMS, services, ssis, kba, plan

• Is statistics over non-indexed columns updated by index rebuild?

  Short answer: no . This question came up today in the MCT discussion group. My gut instinct said no, but I wanted to test it to be certain. But first a brief background: You can rebuild an index using DBCC DBREINDEX or in 2005 (and now preferred) ALTER Read More... Posted Friday, August 10, 2007 2:18 AM from Tibor Karaszi | (Comments Off) Filed under: General, Maintenance

• Be aware: Sp2, maint plans and CHECKDB

  Tony Rogerson brought to my attention that with sp2, a plan that does CHECKDB seems to always do it against the master database. Technicalities seems to be in how SSIS executes SQL commands, separates batches and connection pooling (sp_reset_connection). Read More... Posted Thursday, March 08, 2007 7:44 PM from Tibor Karaszi | (Comments Off) Filed under: Tools, Maintenance

• 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 8:31 PM from Tibor Karaszi | (Comments Off) 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 8:03 PM from Tibor Karaszi | (Comments Off) Filed under: Maintenance