Tag Archives: Maintenance

Book Review – “SQL Server Transaction Log Management” by Tony Davis and Gail Shaw

Posted on May 21, 2013 by

A couple of questions and comments on the Ask.SQLServerCentral.com website have shown some misunderstanding about the use of SQL Server’s Transaction Log files. At about the same time, I was approached by Red Gate as part of their Friends programme … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , , , , | 1 Comment

T-SQL Tuesday #35 – Soylent Inbox

Posted on October 9, 2012 by

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in T-SQL Tuesday | Tagged , , , , | 1 Comment

Querying SQL Server Event Logs to search for DBCC CheckDB output

Posted on September 12, 2012 by

This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 5 Comments

Warning: Wordbreaker, filter or protocol handler used by catalog ‘foo’ does not exist.

Posted on June 21, 2012 by

While monitoring database restores in the DR environment, as you should do, I noticed the following warning message: Warning: Wordbreaker, filter, or protocol handler used by catalog ‘foo_FullText’ does not exist on this instance. Use sp_help_fulltext_catalog_components and sp_help_fulltext_system_components check for … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Red Gate – SQL Server Index Manager – Beta 2

Posted on April 25, 2012 by

Red Gate released the first Beta for their new Index Manager back in December, and I blogged about it then.  They have recently updated the Beta, and so I downloaded it and had another play. First attempt to use it, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Non-Production Servers – SIMPLE recovery?

Posted on December 22, 2011 by

Speaking of putting databases into SIMPLE recovery mode… This post is based on what I use on non-production (eg for QA, or UAT) replicas of production environments – the sort of thing where you need the data, but don’t need … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 6 Comments

Red Gate – SQL Index Manager – Beta

Posted on December 16, 2011 by

Once again, those lovely chaps at Red Gate have come up with a new tool for the DBA – SQL Index Manager, and Grant “Scary” Fritchey (blog|twitter) has even done a video about it on YouTube. So, let’s download it … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 6 Comments

T-SQL Tuesday #024 – Prox & Funx – Maintenance / Release Tip

Posted on November 8, 2011 by

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , | Leave a comment

Index Maintenance for SQL2k

Posted on July 29, 2011 by

Once again, the “smart indexing in SQL2000″ question has raised its ugly head on AskSSC.  Those of you in SQL2005 and above have the opportunity to use some fine index maintenance scripts from Ola Hallengren and Michelle Ufford (among others, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

T-SQL Tuesday #20 – T-SQL Best Practices

Posted on July 12, 2011 by

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , , | 1 Comment