THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Maintenance   (RSS)
Showing page 5 of 5 (45 total posts)
  • 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 than what maint plans allow for. An obvious such in 2005 is to add the CHECKSUM option to ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 25, 2007
  • 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 INDEX ... REBUILD. Rebuilding an index internally creates a new index and when that has ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2007
  • 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). I created a plan to do CHECKDB against all databases, and this is what I found in my errorlog ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 8, 2007
  • 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 if you want to get into details about it. Sure, you can have valid reasons to shrink, after archiving lots of data and needing to free some disk space for ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 25, 2007
  • 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. I haven't tested this, I just learned it from the open newsgroups, but my guess is that perhaps ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 25, 2007
Privacy Statement