THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Maintenance   (RSS)
Showing page 1 of 6 (51 total posts)
  • SQL Updates Newsletter – November 2016

      This is a friendly reminder about a monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the following: Recent Releases and Announcements Recent White Papers, E-Books, Training and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 1, 2016
  • SQL Server 2016 SP1 is now Available

      Some big news today in the world of SQL Server and Visual Studio announced at Connect.  One of the announcements that will spark the interest of most of the people here on this blog is that SP1 for SQL Server 2016 is available for download now.  Why is this important? Well there are a ton of changes related to what features are ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 16, 2016
  • Managing the errorlog file

    I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn't become huge. My main concern with that is that the errorlog contains valuable information. When I do a health check on a SQL Server machine, I want a few months worth of errorlog information available. I typically use my own scripts for this, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2015
  • Ola Hallengrens Maintenance Solution now supports mirrored backup

    You probably know that you can mirror a backup to several destinations, assuming you are on a supported edition (Enterprise or Developer). This is not the same as striping; you can compare striping to RAID 0, and mirroring to RAID 1. Ola now supports mirroring in his maintenance solution, found here. A couple of examples: EXECUTE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 3, 2014
  • How often do you rebuild your heaps?

    Never? You are not alone. None of the maintenance solutions I use includes functionality to rebuild a heap, and that includes Maintanance Plans and Ola Hallengren's maintenance solution. ''So why would you want to rebuild a heap, when it isn't sorted in the first place?'', you ask. The answer is to get rid of Forwarding Pointers, and these can ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • October Update to Rules-Driven Maintenance

    Happy Fall! It’s a beautiful October here in Minneapolis / Saint Paul. In preparation for my home town SQL Saturday this weekend, as well as the PASS Summit, I offer an update to the Rules-Driven Maintenance code I originally published back in August 2012. It’s hard to believe this thing is now more than two years old – it’s been an incredible ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 9, 2013
  • Stats on Stats

    I have been working on new features for the Rules-Driven Maintenance Solution, including per-index maintenance preferences and more selective processing for statistics. SQL Server stats is a topic I knew about at a high level, but lately I have had to take a deeper dive into the DMVs and system views and wrap my head around things like ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on September 18, 2013
  • March Update to Rules-Driven Maintenance

    This month I have a minor update to the Rules-Driven Maintenance code I originally posted back in August 2012. This update has just two enhancements, but they are nice ones, I think: Much improved handling for instances that use database snapshots. Ability to do intra-day differential backups purely by setting maintenance times and limits ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 11, 2013
  • Visualizing Data File Layout III

    This is part three of a blog series illustrating a method to render the file structure of a SQL Server database into a graphic visualization. Previous Installments: Part 1 Part 2 Those that have been reading this series might be be thinking, “Is he going to go there?” Well, the answer is “Yes.” This is the GUID clustered index post that had to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 29, 2013
  • Visualizing Data File Layout II

    Part 2 of a blog series visually demonstrating the layout of objects on data pages in SQL Server Part 1 In Part 1 of this series, I introduced a little demo app that renders the layout of pages in SQL Server files by object. Today I’ll put that app through its paces to show, in vivid color (well, teal, anyway) the destructive power of the famous ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 23, 2013
1 2 3 4 5 Next > ... Last »
Privacy Statement