Database Maintenance Scripting Done Right

Posted by KKline on SQL Blog See other posts from SQL Blog or by KKline
Published on Fri, 18 Feb 2011 13:16:00 GMT Indexed on 2011/02/18 15:31 UTC
Read the original article Hit count: 307

Filed under:

administration

|

automation

|

best practices

|

People

|

Performance

|

SQL Programming

|

Tips

|

tools

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating...(read more)

© SQL Blog or respective owner

Related posts about administration

How much effort is SQL Server 2008 Administration?

as seen on Server Fault - Search for 'Server Fault'
Hi, I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so far did not seem to have very consistent performance… >>> More
Create or extend web application in central administration link missing

as seen on Server Fault - Search for 'Server Fault'
Lately the link to create web applications in central administration for sharepoint server simply isn't there anymore. How can I get it back? >>> More
Microsoft lance System Center : une plate-forme unique et complète pour l'administration systèmes

as seen on Developper.com - Search for 'Developper.com'
Microsoft® System Center est une plate-forme unique et complète pour l'administration des postes de travail, des serveurs, des applications et des périphériques, en environnement physique ou virtuel. Citation: La gamme de produits System Center a pour but de simplifier les… >>> More
Should I be afraid of Linux server administration?

as seen on Server Fault - Search for 'Server Fault'
I've been trying to figure out what to focus on. I finally realized that the root of my quandary is that I am unsure about learning Linux server administration. I have been getting pretty good with PHP/MySQL and web development, but I am not very familiar with Linux. Is it hard to learn? What would… >>> More
Using linked servers, OPENROWSET and OPENQUERY

as seen on SQL Blog - Search for 'SQL Blog'
SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server), a statement that uses a linked server called called OPENQUERY, another… >>> More

Related posts about automation

Documenting applications - automation / semi-automation for screenshots?

as seen on Stack Overflow - Search for 'Stack Overflow'
For me one of the biggest bores of being a developer is writing user documentation. (I am referring to the stuff that gets exported into PDF files files that ship with the product, not comments in code here). The task off adding or updating new bits of text to the existing documentation is OK. However… >>> More
Why the cucumber features keeps running even though it fails?

as seen on Stack Overflow - Search for 'Stack Overflow'
Its a rails 2.3.5 app. I'm using the rspec and cucumber for testing. When I run autospec, it runs correctly with the warning (Not running features. To run features in autotest, set AUTOFEATURE=true.) as below: [~/rails_apps/automation (campaign)?] ? autospec (Not running features. To run features… >>> More
Automation testing tool for Regression testing of desktop application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am working on a desktop application which uses Infragistic grids. We need to automate the regression tests for same. QTP alone does not support this, we need to buy new plug in for same which my company is not very much interested in. Do we have any open source tool for automating regression… >>> More
automation of data format conversion to parent child format

as seen on Stack Overflow - Search for 'Stack Overflow'
This is an excel sheet which has only a single column filled for each row. (explanation : all CITY categories fall under V21 , all handset categories fall under CityJ and so on ) V21 CITYR CITYJ HandsetS HandsetHW HandsetHA … >>> More
Automation: how to automate transforming .doc to .docx?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a bunch of .doc files in a folder which I need to convert to .docx. To manually convert the .doc to .docx is pretty simple: Open .doc in Word 2007 Click on Save As... Save it as .docx However, doing this for hundreds of files definitely ain't fun. =p How would you automate this? >>> More